How could i Calculate fiscal week?

E

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
 
M

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
Click to expand...

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Queries & Fiscal weeks 7
Fiscal YTD Filter 7
Report totally 4
using part of date 3
Create an input form 4
Fiscal week 5
How do i calculate fiscal week of the year 4
FY dates vs. CY dates 1

Top