Fiscal Calendar Weeks

[ak]

Trying to match dates with a fiscal calendar week.

Column A: Site ID
Column B: Data dates (07/29/03 format)
Column C: Need to have dates in column B changed to
match a fiscal calendar by week

Details:
Fiscal calendar for 2003 begins 12/30/02 and ends 12/28/03
12/30/02 is month 1 week 1 (showing up as "1+1")todays'
date 07/29/30 would be month 7 week 5 ("7+5")
12/28/03 is month 12 week 5

So, a 08/01/03 date would bring back 7+5

Thanks
AK

 

[Dick Kusleika]

ak

I replied to your earlier post with a question (sorry for the lateness).
Reply to that post if you can so we keep it in one place.