School Year CalendarThis Excel spreadsheet produces a 14-month calendar through the 2050-51 school year, with minimal initial user input. Keeping a count of student days is automatic; just enter a starting date and the number of student days – that’s it!! Holidays are easily designated and student days are automatically adjusted. This tool makes easy work of the development of a school year calendar and is especially useful for negotiations. The calendar is set to print on 3 pages of standard 8 1/2 x 11 paper in landscape orientation – any smaller will produce results with very small text that is difficult to read. A beginning understanding of Excel is recommended for use.

Click to proceed

View this in “Slide Show” mode for the proper display of animations.

School Year Calendar• Works through 2050 -2051 school year

• If you need it beyond this date, don’t call me – I’ll be 103

• 14-Month calendar produced automatically• Tracks 4 separate schedules at once• Counts total school days• Counts by day of week• Tracks holidays and non-student days• Easter automatically placed• Leap Year automatically placed

Click to proceed

2050 J ULYS M T W T F S

1 2

3 4 5 6 7 8 9

10 11 12 13 14 15 16

17 18 19 20 21 22 23

24 25 26 27 28 29 30

31

Each of the 14 months appears as a typical calendar, but a closer look reveals the hidden structure with the formulas

Click to proceed

2050 J ULYS M T W T F S

1 2

3 4 5 6 7 8 9

10 11 12 13 14 15 16

17 18 19 20 21 22 23

24 25 26 27 28 29 30

31

Let’s take a closer look at an individual calendar day

Click to proceed

1

Each Calendar day is composed of 16 Excel Spreadsheet Cells. The formulas in this spreadsheet are NOT protected so you can see all calculations. The danger in this is that if you accidentally erase a formula, the calendar will not work properly. The advantage is that you can learn how this spreadsheet works and improve it for the future. Just be careful. Any cells that do not contain formulas are open for any text, numbers or formulas you wish to enter.

CAUTION!!

Date – Do not change!!

Open for entry

An entry in any of the 4 cells in this row will set the day not to be counted as a student day

There are formulas in the 8 cells of these two rows – DO NOT CHANGE!!

Click to proceed

BEGINNING YEARSECTION# OF DAYS BEGINNING MONTH BEGINNING DATE

ABCD

Step 1: Fill in Beginning Year

2013

Step 2: Fill in number of Student Days in school year

Section “A” is one of 4 Calendars you can create

Step 3: Fill in the full name of the beginning month of the student school year

Step 4: Fill in the beginning date of the student school year

180 August 27

Click to proceed

2013 AUGUSTS M T W T F S

1 2 3

4 5 6 7 8 9 10

11 12 13 14 15 16 17

18 19 20 21 22 23 24

25 26 27 28 29 30 31

A A A A1 2 3 4

4

Day 1 of Calendar “A” begins on August 27th

Click to proceedStudent day count

2013 BEGINNING YEARSECTION# OF DAYS BEGINNING MONTH BEGINNING DATE

A 180 August 27B 180 August 28CD

You can add up to 4 different schedules

Here a second schedule is added beginning on August 28th

Click to proceed

2013 AUGUSTS M T W T F S

1 2 3

4 5 6 7 8 9 10

11 12 13 14 15 16 17

18 19 20 21 22 23 24

25 26 27 28 29 30 31

A A B A B A B1 2 1 3 2 4 3

4 3

A second Section “B” Calendar that starts on August 28th would appear like this

Click to proceed

2013 SEPTEMBERS M T W T F S1 2 3 4 5 6 7

A A A A A5 6 7 8 9

Holidays and Non-Student Days are set by placing a character in the cell directly above the calendar section designation

Click to proceed

2013 SEPTEMBERS M T W T F S1 2 3 4 5 6 7

A A A A A5 6 7 8 9

Holidays and Non-Student Days are set by placing a character in the cell directly above the calendar section designation

Watch the day count change when the letter “H” is placed directly above the section A calendar designation (any character can be placed in this location – “H” is used here for “Holiday”

Click to proceed

Holidays and Non-Student Days are set by placing a character in the cell directly above the calendar section designation

2013 SEPTEMBERS M T W T F S1 2 3 4 5 6 7

A A A A AH

5 6 7 8 94 5 6 7 8

Click to proceed

A B C D

Days This Month: M 5 Subtotal Days This Year:Section A 21 T 4 Section A 155Section B W 4 Section BSection C T 4 Section CSection D F 4 Section D

Below each month the students days are listed by:

The Month

The Day Count Subtotal for The Year

Click to proceed

TOTAL DAYS OF WEEK

A B C DM 34T 36W 36T 37F 37

TOTAL180

The total Day Count for the year is listed at the top center of the spreadsheet

Click to end