D
DaveB
I have a the following matrix that I want to populate with the number of
Saturdays, Sundays, Mondays, etc. by month, which is based off of a daily
Fiscal Year (i.e. FY 2010) calendar that begins with October 1, 2009 (40087)
and ends with September 30, 2010 (40451) down column A of a tab titled "FY
Calendar" When I change the Fiscal Year to 2011, 2012 I want the matrix
repopulated with the corrrect count of each weekday. I already have the
calendar built which displays each date down column B, the month in column C,
the day of the week in column D and the Weekday (1-7) in column E. If there
is an easier way to do all this I would appreciate the help.
A B C D E F
1 Saturday Sunday Monday Tuesday Wednesday etc...
2 October 5 4 4
3 November
4 December
5 January
6 February
7 March
8 April
9 May
10 June
11 July
12 August
13 September
Saturdays, Sundays, Mondays, etc. by month, which is based off of a daily
Fiscal Year (i.e. FY 2010) calendar that begins with October 1, 2009 (40087)
and ends with September 30, 2010 (40451) down column A of a tab titled "FY
Calendar" When I change the Fiscal Year to 2011, 2012 I want the matrix
repopulated with the corrrect count of each weekday. I already have the
calendar built which displays each date down column B, the month in column C,
the day of the week in column D and the Weekday (1-7) in column E. If there
is an easier way to do all this I would appreciate the help.
A B C D E F
1 Saturday Sunday Monday Tuesday Wednesday etc...
2 October 5 4 4
3 November
4 December
5 January
6 February
7 March
8 April
9 May
10 June
11 July
12 August
13 September