How to calculate the fiscal week

[evlai]

i would need to know how to calculate the fiscal week of the year.
first week of the year should start from Feb 1, instead of january

For example,
1-FEB-2005 --> WW 1
i would appreciate if someone could help me to solve this problem.
Thanks

 

[JE McGimpsey]

i would need to know how to calculate the fiscal week of the year.
first week of the year should start from Feb 1, instead of january

For example,
1-FEB-2005 --> WW 1
i would appreciate if someone could help me to solve this problem.
Thanks

one way:

A1: <date>
B1: =INT((A1-DATE(YEAR(A1-31),2,1))/7)+1

If you need the "WW ", format the cell as "WW 0", or if you don't need
to use the result as a number:

B1: =TEXT(INT((A1-DATE(YEAR(A1-31),2,1))/7)+1,"WW 0")