Docstoc

Yearly Calendar

Document Sample
Yearly Calendar Powered By Docstoc
					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


				
DOCUMENT INFO
Shared By:
Tags: calendar, excel
Stats:
views:1163
posted:1/3/2008
language:English
pages:4