2015-2016 School Calendar Templates
Download a School Calendar template for the 2015-2016 or 2016-2017 school year and easily edit it using Excel. Use our templates to create calendars for public, private, or home schools. The templates include both monthly and yearly 2015-2016 & 2016-2017 calendars, and the yearly calendars work for any school year.
If you want to quickly print a school year calendar, see our printable academic calendars page. If you want a monthly school calendar starting in January, like our printable calendars, or want to choose the starting month, try our new perpetual calendar template.
School Calendar Template Collectionfor Excel and OpenOffice
"No installation, no macros - just a simple spreadsheet" - by Jon Wittwer
This download is our entire collection of school year calendars for Excel 2003 (.xls files) including a monthly 2013-2014 calendar and 2014-2015 calendar, as well as all of the school-year calendars listed below in .XLS format.
If you are using Excel 2007 or later, you will probably want to use our newer .XLSX files, and you can download those separately below. Newer versions of Excel make it easier to choose different color schemes (via Page Layout > Colors). See the very bottom of this page for information about how to create a PDF of your 2013-2014 or 2014-2015 calendar to post on your school's website.
14-Month School Year Calendarfor Excel and OpenOffice
This 2015-2016 school-year calendar works for any year and shows 14 months on a page (starting with the month of your choice). Like the other school-year calendars, you can make a list of special events and format cells differently for different types of events.
School Event Calendarfor Excel and OpenOffice
Use this template to create a 12-month school event calendar with dates listed for important events and holidays. Some U.S. holidays are included and update automatically when you change the year. Works for any year, with a Monday-first option.
School Year Event Calendarfor Excel and OpenOffice
A 14-month school event calendar for listing the year's events in detail, with mini-calendars on the left side. Works for any year, with a Monday-first option. Includes some U.S. holidays that update automatically when you change the year.
School Year Calendarfor Excel and OpenOffice
A full-year (12-month) school-year calendar, good for any year, and you can choose the start month. This is a very popular template for creating and publishing a school calendar.
You can share the calendar by converting it to a PDF. Just print to a PDF driver. Or, if you are using Excel 2010 or later, you can save the file as a PDF.
District School-Year Calendarfor Excel and OpenOffice
This calendar template is general enough to be used for a single school, but we originally created it for a school district. It allows you to show a full school year and list specific events for different schools. You can change the labels in the "Category of Events" sections to be the names of the schools in the district.
To create a PDF to share with parents and faculty, simply go to File > Save As and save it as a PDF.
School Calendar Color Schemes
New: The new .XLSX versions (for Excel 2007 or later) are theme-enabled, meaning that you can change the color scheme by going to Page Layout > Colors.
The calendar collection includes a number of blank calendar spreadsheets with different color schemes. To quickly change the color palette in one of the templates, you can open one of the blank calendars then go to Tools > Options > Color Tab and select the workbook from the "Copy Colors From" drop-down box.
All of these templates except for the class schedule template, use the colors in the 2nd column of the color palette. You can change the color scheme by changing the Hue of each of the colors in the 2nd column. This is done by going to Tools > Options > Color tab. Then select the color and click on the Modify button and go to the Custom tab. Select "HSL" from the Color Model drop-down box and change the Hue value. Assign the same Hue value to each of the colors in the column (usually only the top and bottom colors are used in the calendars, though).
Publishing Your School Calendar as a PDF
I often get asked for permission and/or help to create a PDF that can be placed on a school's website. That is what these templates have been designed for, but you must provide a reference link to Vertex42.com on the website or in the footer of the PDF. If you place a link on your site, feel free to link to this page or one of our other free calendar pages.
If you own Adobe Acrobat Professional, you can create a PDF from an Excel spreadsheet by simply printing to the Adobe PDF driver. If you are using Excel 2010 or Later, then you can create a PDF by just going to Save As and choosing the PDF format.
PromoPDF is a free tool for creating PDFs from almost any Windows application.