Fiscal Week = What Dates?

[Daveyk01]

If a user is asked for the Fiscal Week how can I have VBA determine what the start date of a Fiscal Week is?

I know how to enter a Date and determine what fiscal week it is in. I have stolen <grin> enough code to do that.

Often my manager will tell me to generate a so and so report for Fiscal Week #14 (for example). I have to manually figure of the start and stop dates for the report. I would like him to be able just to be asked for the Fiscal week and Bam! the report is generated without having to enter a start and stop date.

I may just be very tired right now, but I can not find an example of this to "borrow".

Thanks!

 

[namliam]

The trick to doing this is to determain first Week #1 of the year required. Once you have done that.... it is as easy as taking that date and adding 7 days (per week) * 14 weeks (as per your example) to Week #1 and you have your answer...

See how you get on, post back any more questions you have.