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