fiscal week

  1. N

    Looking for an faster formula to calculate the weeknum for fiscal year

    Hi all, I have an formula today that I use to calculate the FY week number. The problem is that with my table, 80k+ rows and expanding, this is a very slow process. Does anyone have an suggestion on how to speed up this formula? =WEEKNUM(A2,1)-26+IF(MONTH(A2)<7,52,0)
    • Norty
    • Thread
    • calculate fiscal week fiscal year formula slow
    • Replies: 3
    • Forum: Excel Questions
  2. E

    Calculating a Fiscal Week

    Hey guys, I'm trying to come up with a formula that will calculate the fiscal week based on today's date, but I'm having a hard time with it because my company uses a strange fiscal start date. Our fiscal year starts on the Sunday before the first Wednesday that falls in February. For example...
  3. M

    Formula to calculate fiscal year week based on date

    Hello, I have a two column spreadsheet, the first column contains a date and the second column should calculate the fiscal week for the date in the first column. The fiscal year begins on 7/1 of each year and each week begins on Sunday. The below formula is close but it calculates the fiscal...

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top