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

[Norty]

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?

[COLOR=#333333]=WEEKNUM(A2,1)-26+IF(MONTH(A2)<7,52,0)[/COLOR]

 

[mole999]

If you copy paste special > values the first 78K, then you formula only needs to work on the current 2K odd as the rest will be static

 

[Norty]

If you copy paste special > values the first 78K, then you formula only needs to work on the current 2K odd as the rest will be static

That was interesting.. I see how this should speed everything up, but it didn't. Even when I changed all 80k rows to be static the sheet(that consist of a big table) still takes a long time to calculate every time I make a change.

So the problem must be with the formulas that refers to the this table. I'll have to look into them instead.

Thanks for your help =)

 

[mole999]

so now look for volatile functions, things that recalculate every time you update like NOW() that supports other cells