Site icon INDZARA

Any Year (2021, 2022) Calendar – Free Google Sheet Template

You can plan ahead for the upcoming year by mapping out holidays and important events on a Google Sheets Calendar. We have provided 20 different design templates for the 2020 Calendar that are customizable and print-ready. The design templates include annual (yearly), monthly, weekly and daily calendars.

What more? The templates are expandable so you can continue using them for the forthcoming calendars like 2021, 2022 etc., as well. This Calendar could be used for personal as well as professional purposes. 

This template is designed for Google sheets, but if you are looking for an Excel template, please visit the 2021 Excel Calendar.

2020 Calendar Template – Monthly – January 2020

Through this article, you will understand:

How to download the 2020 Calendar in Google Sheets Template

Click on the link above to access the Google Sheet. Make a copy of the Sheet as shown in the screenshot below. Save this template on your Google Drive. 

How to make a copy of Google Sheet

Note: Once you open the saved template, you can see that the Dashboard and Calendar are populated automatically. You have to just configure your inputs to customize the calendar according to your needs. 

Features of the 2020 Calendar Google Sheets Template

How to Use the Template

Overview of steps

  1. Enter Basic settings
  2. Choose Weekends
  3. Enter Holidays
  4. Enter your personal or company Events
  5. Pick a Calendar design
  6. Print or export the calendar to PDF

Step 1: Enter Basic Settings

Basic Settings – 2020 Excel Calendar Template
Change Beginning Month of Calendar
Start Week from any day

Step 2: Choose Weekends

Choose Weekends
Chosen Weekends – Sample

In the above image, we have chosen Sundays and Saturdays as weekends. Hence, they appear in red font on all the calendars. 

Step 3: Enter Holidays

Enter the list of holidays for your personal/professional/company/business needs in the Holidays table. The template displays a list of holidays in the U.S. and India for reference.

Enter Holidays for 2020 Calendar

Step 4: Enter your personal or company events

In addition to holidays, you can either add personal events or your company’s events in the calendar based on your needs. The following screenshot features some sample personal events for your reference.

Google sheets schedule template 2020 – Enter events to display on calendar

Step 5: Pick a Calendar Design from the 20 Designs

20 Calendar Designs in Google Calendar 2020 Template
20 Calendar Sheets

Note: If you change the sheet names of the calendars, then hyperlinks in the Pick a Calendar sheet will not work.

Step 6: Print the Calendar or Export to PDF

Printing the Calendar
Saving the Calendar as PDF

20 Calendar Designs

Let’s review the features of each of the 20 calendar designs of free google calendar template 2020:

Calendar Design 1

1 Page 12 Months – 4 X 3 

2020 Calendar Design 1 – 1 Page 12 Months – 4 X 3

Note: When both Event and Holiday fall on the same day, Event is prioritized and event color is displayed.

Calendar Design 2

1 Page 12 Months – 3 X 4

2020 Calendar Design 2 – 1 Page 12 Months – 3 X 4

Calendar Design 3

1 Page 12 Months – 2 X 6 with Events

2020 Calendar Design 3 – 1 Page 12 Months – 2 X 6

Calendar Design 4

1 Page 12 Months –  6 X 2 with Events

2020 Calendar Design 4 – 1 Page 12 Months – 6 X 2

Calendar Design 5

1 Page 12 Months –  12 X 42 with Events

2020 Calendar Design 5 – 1 Page 12 Months – 12 X 42 with Events

Calendar Design 6

1 Page 12 Months –  12 X 31 with Events

2020 Calendar Design 6 – 1 Page 12 Months – 12 X 31 with Events

Calendar Design 7

6 Pages – Planner

2020 Calendar Design 7 – 6 Pages – Planner

Calendar Design 8

1 Page – 54 Weeks – with Events

2020 Calendar Design 8 – 1 Page – 54 Weeks – with Events

Calendar Design 9

12 Pages – Monthly

2020 Calendar Template – Monthly – January 2020

Calendar Design 10

6 Pages – with Events

2020 Calendar Design 10 – 6 Pages with Events

Calendar Design 11

4 Pages – with Events

2020 Calendar Design 11 – 4 Pages with Events

Calendar Design 12

3 Pages – 4 Months on each page

2020 Calendar Design 12 – 3 Pages with Events

Calendar Design 13

2 Pages – 6 Months on each page

2020 Calendar Design 13 – 2 Pages – 6 Months each

Calendar Design 14

12 Pages – Monthly – with Events

2020 Calendar Design 14 – 12 Pages with Events

Calendar Design 15

12 Pages – Monthly – Type Events

2020 Calendar Design 15 – 12 Pages – Type your events

Calendar Design 16

12 Pages – Picture Calendar

2020 Calendar Design 16 – Picture Calendar
Adding Image to the Calendar
Choosing Images for the Calendar

Calendar Design 17

12 Pages – Quotes Calendar

2020 Calendar Design 17 – Quotes Calendar

Calendar Design 18

1 Page – Weekly Calendar

2020 Calendar Design 18 – Weekly Calendar

Calendar Design 19 (Daily Calendar)

1 Page – Daily Calendar

2020 Calendar Design 19 – Daily Agenda Calendar

Calendar Design 20 (Two Years Calendar)

1 Page – 2 Years Calendar

2020 Calendar Design 20 – Two years Calendar

TIPS TO CUSTOMIZE THE 2020 CALENDAR TEMPLATE

1. How to change formatting (colors/fonts/borders)?

The google spreadsheet calendar template 2020 designs are completely customizable and formatting is no exception. You can style the calendars as per your favourite colors and fonts. This won’t affect the functionality of the template calendar negatively. 

Steps: 

Select Cells to change formatting

2. How to change Event and Holiday colors?

Using conditional formatting, you can change the event and holiday colors. 

Open Conditional Formatting From Menu
Conditional formatting rules for Weekends Holidays and Events
Conditional formatting – Edit Format for a rule

3. How to change the order in which events/holidays appear on the calendar?

Usually, Holidays and Events appear on the calendar in the way they have been listed on the table (in the Settings sheet). If you have entered the Holidays and Events in a random order on the table then you can sort the list to order them appropriately. You can sort them in ascending order (A – Z) or in descending order (Z-A). And click on “OK.”

Sort Holidays by Ascending or Descending Order in Holidays table

4. How to change the date format for events and holidays?

In the template we have used the date format MMM-DD (example May-05) since months could sometimes be misinterpreted as days in other countries. However, it is easy to change the date format as per your needs. 

Change date formats using Format Menu option
Choose one from the standard date formats

5. How to unprotect (unlock) sheets?

The above-mentioned customizations can be made normally. However, for further customizations, you have to unprotect the sheets. 

INDZARA is the password for unprotecting the sheet.Once the customizations are done, protect the sheets again to avoid any accidental edits on the sheets.

You may also want to check some of our Google Sheet Templates:

Employee Recruitment Tracker

Free Google Sheets

Exit mobile version