How could i Calculate fiscal week?

[evlai]

I would need to know how could i calculate fiscal week
For example,

The 1st week of the fiscal year = Feb 1, 2005
September 20th, 2005 = week 34

Please help. thanks

 

[Mike Painter]

I would need to know how could i calculate fiscal week
For example,

The 1st week of the fiscal year = Feb 1, 2005
September 20th, 2005 = week 34

Please help. thanks

I didn't note when you started in my other response. The only changes made
to my suggestion is that a function will be a better choice.

Public Function OffSetFiscal(RealDate As Date)

OffSetFiscal = Format(RealDate, "ww") - 5

End Function

Gives the number you want.