A
ak
Current spreadsheet:
Column A contains site id info (~400)
Column B contains dates in 07/29/03 format
Need to do:
Analyze dates in column B with a fisal calendar and
return the value in a month+week of the month format.
The fiscal calendar for 2003 starts with December 30,2002
through January 5th, 2003 as week #01. Today's date of
7/29/03 would be in week number 31. Every Monday is the
start of a new fiscal week. So the month of July has 5
fiscal weeks, and August has only 4.
Example:
07/29/03 would be 7+5
Thanks,
ak
Column A contains site id info (~400)
Column B contains dates in 07/29/03 format
Need to do:
Analyze dates in column B with a fisal calendar and
return the value in a month+week of the month format.
The fiscal calendar for 2003 starts with December 30,2002
through January 5th, 2003 as week #01. Today's date of
7/29/03 would be in week number 31. Every Monday is the
start of a new fiscal week. So the month of July has 5
fiscal weeks, and August has only 4.
Example:
07/29/03 would be 7+5
Thanks,
ak