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