2021-2022 Academic Calendar Templates

Click to See Full Template

Version
19'526 Downloads
6.7 MB File Size
January 3, 2022 Updated
2 Number of comments
★★★★★
★★★★★
Rating

Download this template for free
Get support for this template

table of content

As usual, around this time every year, you can download and use the latest school calendar templates. There several models of those calendar templates you can download for free.

You can adjust this calendar to meet your need in a single spreadsheet only now. You don’t have to choose specific spreadsheets from 4 spreadsheets starting from July or August. Now, you can set it up within a single spreadsheet. Months and Dates are automatically adjusted based on your setup choices. It should eliminates date placement error that sometimes occurred because of manual placement.

The first three calendars are academic calendar templates with similar layouts with previous models, while the next threes have new layouts and functions which I think should suit your needs on mapping your school events and distribute it as your official ones.

Here are short description of each calendars and its new functions, so you can use it properly.

This setting applied to all free models below :

To set your calendar to start from a specific month, you can select July, August and September in Starting Month box.
To set your calendar to have 12 or 13 months period, you can select it from Number of Months box
To set your calendar to start its day from Sunday or Monday, you can select it from Starting Day box

Each boxes, that you can see in picture above, are placed at the right side of each calendars, and they might have different colors.

CALENDAR TEMPLATE MODELS

Model 1 : One page landscape calendar, event description in separate worksheet, fixed and consecutive dates in separate tables

Steps to mark the dates in the calendars are remain the same with previous version. Just type fixed and consecutive dates in respective tables. Fixed tables are tables that you can only put one date to be marked inside the calendar, while consecutive dates tables are tables that you can mark dates in calendar sequentially by typing the start and end dates of dates period you want to be marked. There are 3 tables for fixed dates and 3 tables for consecutive dates tables where all of them won’t have similar colors.

Model 2 : One page portrait calendar, event description in the middle of calendar within the same page, fixed and consecutive dates in separate tables

Different from model 1, this model only has one fixed dates table and one consecutive dates table, put in middle of the calendar. To differentiate dates colors, you must put color codes next to respective event dates.

Model 3 : One page linear calendar, event description at the bottom of calendar within the same page, fixed and consecutive dates in separate tables

Steps to mark dates in the calendar are the same with model 1.

Model 4 : One page portrait calendar, event description at the left side of calendar within the same page, fixed and consecutive dates within the same table

Model 5 : One page landscape calendar, event description at the right side of calendar within the same page, fixed and consecutive dates within the same table

This is one of new models released this year. In this model, fixed and consecutive dates are within the same table. It should help you to order and group dates based on quarter or half school period. To mark dates, you must type the dates and select the month, these part will be seen when the calendar is printed, and after that you must set the year and its color codes next to respective events. There parts are put outside the calendar so you have options to hide it or not show it when you print the calendar.

Model 6 : One page portrait calendar, event description at the right side of calendar within the same page, fixed and consecutive dates within the same table

Model 7 : One page linear calendar, event description at the bottom of calendar within the same page, fixed and consecutive dates within the same table, divided by months

How to put color markers is the same with model 5, except those table already grouped in separate months. You just need to put dates, description and its color codes. There are options to hide color codes to help you hide it when you print the calendar.

Model 8 : One page linear calendar, two months area separation, event description at the bottom of calendar within the same page, fixed and consecutive dates within the same table, divided by months

Model 9 : One page landscape calendar, two parts of months arrangement, event description at the bottom of calendar within the same page, fixed and consecutive dates within the same table, divided by months

Model 10 : One page portrait calendar, months are split into 2 parts, event description at the right side of each calendar parts within the same page, fixed and consecutive dates within the same table, divided by months

Model 11 : One page portrait calendar, months are split into two parts, event description at the left and right side of each calendar parts within the same page, fixed and consecutive dates within the same table

Since this one has event tables next to month names, all you need to colorize the dates is to type the dates in respective month tables.

Model 12 : One page portrait calendar, months are at the left and right side, event description in the middle at the left and right side of each calendar parts within the same page, fixed and consecutive dates within the same table

Although all calendar models below are intended for school event scheduling purposes, you can find it useful for your own events which have period from July this year to July next year. If you need calendar templates that start from January, please take a look at different calendar templates on this website.

Model 13: This is a yearly school calendar template you can use for any years. This template allows you to use it every year by changing its starting year and renew all school event dates. You can start from 2018/2019 school period and reuse it for 2019/2020 period and so on. This template should be a solution for you who rely on my one year period template and always do year adjustment every time new academic year is started.

There are 12 models of this calendar included.

HOW TO USE YEARLY ACADEMIC CALENDAR

It is very simple. Just open the calendar and you will find calendar with conditional formatting formula that will mark dates with specific colors. You just need to entry dates and their description in respective tables. There are tables for single dates (you can fill only one date per row) and period dates (you need to type start and end dates). In this free version, event tables are in separate worksheet and only three color markers for single dates and three color markers for consecutive dates.

Remember that you need to set several parameters before starting to fill your school dates.

YEAR SETUP

Go to Starting Year cell and type starting year of your school period. To reuse it for next school period, just replace it with another year and dates inside the calendar will follow accordingly.

MONTH SETUP

Go to Starting Month cell and change its content to July, August and September to make the school calendar starts from selected month. These three months are the most common school months. Let me know if you need to set starting month other than those three months above.

NUMBER OF MONTH SETUP

Go to Number of Month cell and select between 12 and 13 as the number of months.

STARTING DAY OF THE WEEK SETUP

Go to Starting Day cell and choose between Sunday and Monday as the starting day in the first column of the week. There is no color differentiation for Sunday or Weekend days.

COLOR MARKER DESCRIPTION SETUP

Go to event tables and and type respective event description that you want to mark inside the calendar. There are different color marker setup variation, but you can only have it in several models in paid version. You will get 13 calendar models in that version. There are tabular and linear calendars with variety of school dates and description placements. All of them are customizable and you can reuse it without any year limitation. Also, there are some calendar models with one table where you can put either single or consecutive dates and apply particular color markers for those dates.