- Canva’s calendar templates are customizable, so you can edit them to your needs. That means you can create calendars for 2020 and 2021, or you could leave the dates blank. You can even make yours extra special by adding in personal events. A nice extra touch is to add your favourite photos to the calendar.
- A printable 2021 annual calendar has the US holidays. This yearly calendar is available in a Horizontal layout. This free editable calendar template is also available in Doc / Docx, PDF, and jpg formats for download. Preview Download. Download this annual blank calendar template for 2021 in a landscape format document.
Hi Wes,
Microsoft boasts a vast collection of premium and free calendar templates to help keep your days, weeks, and months organized and stress-free. PowerPoint and Excel calendars are designed for personal, school, and business settings and are ready to be filled with your special dates and upcoming events: a friend’s birthday, a final exam, or an.
The Calendar template in Numbers has lots going on 'behind the curtain' but you can raise the curtain and see what is going on.
Click on each table in turn and Format Panel > Table > click on Table Name.
Click on the Month and Year table (top left and Menu > Table > Unhide All Rows to see some very clever formulas.
The Calendar table changes by month and year, but only the even numbered rows (2, 4, 6...) to insert the correct day of the month.
The odd numbered rows (3, 5, 7...) do not change; they repeat whatever text they contain. That is why a note repeats every month.
Barry has hit the nail on the head. That template is designed such that you duplicate the 'Monthly' Sheet (Tab) 11 times and select another month. Rename the tabs as January, February...
That way, each Sheet has a clean Calendar table to receive notes for that month.
Have a browse around each table and cell to see the formulas.
Regards,
Ian.
P.S. there was a discussion on this some time ago. I will search for it. I think that the conclusion was that the Calendar Template was created by a very clever person, and whilst it seems complicated, it is an excellent example of the Charm of Numbers. Ian.
Dec 22, 2017 3:12 PM
Download a School Calendar template for the 2021-2022 or 2022-2023 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 school 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.
Monthly School Calendar Template
for Excel and Google SheetsDownload
⤓ Excel (.xlsx)Other Versions
License: Private Use (not for distribution or resale)
'No installation, no macros - just a simple spreadsheet' - by Jon Wittwer
Description
This download contains a collection of 14-month calendars with each month on a separate worksheet (from July to August of the following year). The collection currently contains calendars for the school years 2018-2019 through 2022-2023, including versions that show the week as Monday-Sunday.
Excel makes it easy 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 2021-2022 calendar to post on your school's website.
14-Month School Year Calendar
for Excel and OpenOfficeDownload
⤓ Excel (.xlsx)License: Private Use (not for distribution or resale)
Description
This 2021-2022 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.
Download
⤓ Excel (.xlsx)Pages Calendar Template Mac
License: Private Use (not for distribution or resale)
Description
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 and includes a Monday-first option.
School Year Event Calendar
for Excel and OpenOffice⤓ DownloadLicense: Private Use (not for distribution or resale)
Description
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.
Download
⤓ Excel (.xlsx)Other Versions
License: Private Use (not for distribution or resale)
Description
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 Calendar
for Excel and OpenOfficeDownload
⤓ Excel (.xlsx)Other Versions
License: Private Use (not for distribution or resale)
Description
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.
Horizontal School Year Calendar
If you are looking for something new and a little different, check out the horizontal yearly calendars. One of the templates was designed specifically for showing school events.
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. You can also change the theme fonts by going to Page Layout > Fonts.
Free Printable Calendars For Mac
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.
Newer versions of Excel (2010 or later) allow you to choose 'Adobe PDF' as a printer option when you print. You can also choose 'PDF' as a file type when you use Save As.