ABCDEFGHIJKLMNOPQRSTUVWXYZAA
1
School Year Calendar Template
2
https://www.vertex42.com/calendars/school-calendar.html
© 2007-2018 Vertex42 LLC
INSTRUCTIONS
3
4
Year:2022Beginning Month:8Start day:1 1:Sunday, 2:Monday« Choose the year and beginning month
5
Note: If you choose Monday as the start day, you will need to modify some of the formatting in the calendars (bold vs. non-bold days).
6
7
8
Name of SchoolPublishing your calendar. If you want to publish a school calendar, you must ensure that it includes the following note and URL in the footer: Calendar Templates by Vertex42.com - https://www.vertex42.com/calendars/school-calendar.html
9
2022-2023 School Calendar
10
August 2022September 2022October 2022
11
SuMTuWThFSaSuMTuWThFSaSuMTuWThFSaConverting the calendar to a PDF. To publish a school calendar on your website, you should first convert it to a PDF. The best way to do that is to either print to a PDF driver, or in Excel 2010/2013 you can go to Save As and select PDF.
12
1234561231
13
78910111213456789102345678
14
14151617181920111213141516179101112131415
15
212223242526271819202122232416171819202122Background colors. The background color for the weekends and blank days are controlled using conditional formatting. To edit the color, go to Home > Conditional Formatting > Manage Rules and select "This Worksheet" from the drop-down box.
16
2829303125262728293023242526272829
17
3031
18
19
November 2022December 2022January 2023Changing the color scheme. You can change the color scheme by going to Page Layout > Themes > Colors.
20
SuMTuWThFSaSuMTuWThFSaSuMTuWThFSa
21
123451231234567
22
678910111245678910891011121314Overwriting formulas. You can overwrite a formula to place an "H" in place of a holiday for example. Be very careful if you copy/paste days so that you don't mess up the formulas. You can copy/paste the formulas for the days within the same month, but not between months.
23
131415161718191112131415161715161718192021
24
202122232425261819202122232422232425262728
25
2728293025262728293031293031
26
27
View the Print Area. To view the current print area, first view the Print Preview (Ctrl+P) then return to the Home tab. Or, go to View > Page Break Preview. The print area will become highlighted with a dashed line. To choose a new print area, select the cells you want to include and go to Page Layout > Print Area > Set Print Area.
28
February 2023March 2023April 2023
29
SuMTuWThFSaSuMTuWThFSaSuMTuWThFSa
30
123412341
31
5678910115678910112345678
32
12131415161718121314151617189101112131415
33
192021222324251920212223242516171819202122
34
26272826272829303123242526272829
35
30
36
37
May 2023June 2023July 2023
38
SuMTuWThFSaSuMTuWThFSaSuMTuWThFSa
39
1234561231
40
78910111213456789102345678
41
14151617181920111213141516179101112131415
42
212223242526271819202122232416171819202122
43
2829303125262728293023242526272829
44
3031
45
46
School Closed
PD
Employee Planning (no school for students)
« Use the Format Painter to copy the format from one cell to another
47
Early Release Day
Report Cards
48
Parent Teacher Conferences
First and Last Day of School
« Copy and paste these Shapes to highlight specific days
49
New Teachers
End of Quarter/Semester
50
« Make a list of important dates. Enter dates as text by entering an apostrophe before the date, like 'Aug 8
51
52
Graduation :
53
Day Count per quarter
54
1=2=3=4=
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100