January 2007 - December 2007 January 2007
S 7 14 21 28 M 1 8 15 22 29 T 2 9 16 23 30 W 3 10 17 24 31 Th 4 11 18 25 F 5 12 19 26
1
Yearly Calendar
February 2007
S 4 11 18 25 M 5 12 19 26 T 6 13 20 27 W 7 14 21 28 Th 1 8 15 22 F 2 9 16 23
2
March 2007
S 4 11 18 25 M 5 12 19 26 T 6 13 20 27 W 7 14 21 28 Th 1 8 15 22 29 F 2 9 16 23 30
3
Sa 6 13 20 27
Sa 3 10 17 24
Sa 3 10 17 24 31
April 2007
S 1 8 15 22 29 M 2 9 16 23 30 T 3 10 17 24 W 4 11 18 25 Th 5 12 19 26 F 6 13 20 27
4
May 2007
S 6 13 20 27 M 7 14 21 28 T 1 8 15 22 29 W 2 9 16 23 30 Th 3 10 17 24 31 F 4 11 18 25
5
June 2007
S 3 10 17 24 M 4 11 18 25 T 5 12 19 26 W 6 13 20 27 Th 7 14 21 28 F 1 8 15 22 29
6
Sa 7 14 21 28
Sa 5 12 19 26
Sa 2 9 16 23 30
July 2007
S 1 8 15 22 29 M 2 9 16 23 30 T 3 10 17 24 31 W 4 11 18 25 Th 5 12 19 26 F 6 13 20 27
7
August 2007
S 5 12 19 26 M 6 13 20 27 T 7 14 21 28 W 1 8 15 22 29 Th 2 9 16 23 30 F 3 10 17 24 31
8
September 2007
S 2 9 16 23 30 M 3 10 17 24 T 4 11 18 25 W 5 12 19 26 Th 6 13 20 27 F 7 14 21 28
9
Sa 7 14 21 28
Sa 4 11 18 25
Sa 1 8 15 22 29
October 2007
S 7 14 21 28 M 1 8 15 22 29 T 2 9 16 23 30 W 3 10 17 24 31 Th 4 11 18 25 F 5 12 19 26
10
November 2007
S 4 11 18 25 M 5 12 19 26 T 6 13 20 27 W 7 14 21 28 Th 1 8 15 22 29 F 2 9 16 23 30
11
December 2007
S 2 9 16 23 30 M 3 10 17 24 31 T 4 11 18 25 W 5 12 19 26 Th 6 13 20 27 F 7 14 21 28
12
Sa 6 13 20 27
Sa 3 10 17 24
Sa 1 8 15 22 29
Date Formulas
Months
January February March April May June July August September October November December Month Names: This named range (months) is used as the input for the combo box. The Start Date: This named formula (startDate) is the first day of the first month in the yearly calendar, defined by the month and year chosen by the user.
startDate
1/1/2007
Method for creating a monthly How it Works: calendar without using arrays January 2007 Sun Mon 1 2 1 2 3 4 5 6
1 7 14 21 28 8 15 22 29
Using arrays
This calendar is included to show how the more complex array function works. Note the use of mixed absolute and relative Tue Wed references that enable you Thu to copy the Fri formula down and across. This is basically 3 4 5 6 what the array formula is doing for you. 5 2 3 4 9 16 23 30 10 17 24 31 11 18 25 12 19 26
Sat 7
6 13 20 27
January 2007
S 7 14 21 28
monthNames startDates January February March April May June July August September October November December January February March April May June July August September October 1/1/2007 2/1/2007 3/1/2007 4/1/2007 5/1/2007 6/1/2007 7/1/2007 8/1/2007 9/1/2007 10/1/2007 11/1/2007 12/1/2007 1/1/2008 2/1/2008 3/1/2008 4/1/2008 5/1/2008 6/1/2008 7/1/2008 8/1/2008 9/1/2008 10/1/2008
Adding additional months: Insert a new row (before the last month in the list) and copy the formulas down.
November December January February
11/1/2008 12/1/2008 1/1/2009 2/1/2009
Using arrays
January 2007
M 1 8 15 22 29 T 2 9 16 23 30 W 3 10 17 24 31 Th 4 11 18 25 F 5 12 19 26 Sa 6 13 20 27