mplees
Active Member
- Joined
- Feb 6, 2006
- Messages
- 351
Hi,
Hope someone can help me out with this problem - which is a problem with two parts.
Firstly, I need a formula that will calculate the week number based on my company's financial year. The financial year always starts on a Sunday, & in the current year (2007/2008), week 1 commenced on Sunday, September 16th, and will end on Saturday, September 13th 2008. The next financial year will then commence on Sunday, September 14th 2008. It appears that the financial year has 52 weeks. I don't have access to the analysis toolpak, so really need a formula that doesn't use this feature.
My second problem is that I need to be able to calculate a period based on the date or week number. There appears to always be 4 weeks in each period, and in this financial year there are obviously 13 periods. P1 starts Sept 16th & ends Oct 13th, P2 starts Oct 14th and ends Nov 10th, & so on. Is there a way to construct a formula that will calculate the period?
All help most gratefully received!
Kind regards,
Mark
Hope someone can help me out with this problem - which is a problem with two parts.
Firstly, I need a formula that will calculate the week number based on my company's financial year. The financial year always starts on a Sunday, & in the current year (2007/2008), week 1 commenced on Sunday, September 16th, and will end on Saturday, September 13th 2008. The next financial year will then commence on Sunday, September 14th 2008. It appears that the financial year has 52 weeks. I don't have access to the analysis toolpak, so really need a formula that doesn't use this feature.
My second problem is that I need to be able to calculate a period based on the date or week number. There appears to always be 4 weeks in each period, and in this financial year there are obviously 13 periods. P1 starts Sept 16th & ends Oct 13th, P2 starts Oct 14th and ends Nov 10th, & so on. Is there a way to construct a formula that will calculate the period?
All help most gratefully received!
Kind regards,
Mark