2020 Calendars for Excel

19 free printable yearly calendar templates for 2020 in Microsoft Excel format

Sponsored links
Multi-purpose Microsoft Excel calendars 2020 for the United States – practical, versatile, customizable and free to download and print. These templates are suitable for a great variety of uses: holiday planner, trip planner, journey planner, travel planner, yearly overview, yearly planner, company calendar, office planner, holiday calendar, school calendar, college calendar, university planner, annual holiday chart and leave planner, attendance calendar, shift calendar, shift planner, yearly calendar, custom calendar, family planner, period calculator, ovulation calculator, pregnancy calendar, simple project management tool, team collaboration tool, EMM, ERP/MRP, SCM, PLM, CRM, HR, reporting, to do list, task management, appointment calendar, appointment planner, desktop calendar, wall calendar, wall planner, blank calendar, as time sheet, time management tool or time tracking software, for process management, process optimization, help desk administration, business administration, business intelligence and analytics, automation, forecasting, finance, accounting, financial planning, tax planning, sales & marketing, customer service, customer relationship management, process & supply chain management, data analysis, availability and booking, as pocket calendar, advertising calendar, community calendar, staff planner, employee scheduler, employee absence tracker, people planner, vacation planner, annual journal, events planner, scheduler, shared scheduling, date calculator, yearly record, work schedule, wedding planner, fiscal year planner, register or report and many more...

The variations range from yearly calendars on a single page (the whole year at a glance) to quarterly calendars on 4 pages (3 months/1 quarter on one page). The templates are blank, printable and macro-free and are easy to edit, amend, save and use again later. They are saved in Microsoft Excel ".xlsx" format and can be used with the newer versions of Excel that support the XML document standard (files with ".xlsx" extension - Excel 2007, 2010, 2013, 2016, 2019, 2021 and Office 365). If you have one of the older versions of Excel that only supports the ".xls" format (Excel 2000, 2002/XP & 2003), or if you don't have Excel installed, use Microsoft Office Online or one of the free Microsoft Excel/Microsoft Office alternatives FreeOffice PlanMaker, LibreOffice Calc and Google Sheets, which are all free of charge (OpenOffice Calc unfortunately has minor formatting problems when opening our calendars). Also compatible with Microsoft Office for Mac (macOS) and Microsoft Office mobile for iPad/iOS, Android and Windows 10 mobile. Read more about the various Excel versions and file formats on Wikipedia. More free Excel calendar templates are also available from the Microsoft template gallery (calendar section).

The files may be used free of charge for non-commercial use, provided that the Calendarpedia logo, the copyright notice ("© Calendarpedia®, www.calendarpedia.com") and the disclaimer ("Data provided 'as is' without warranty") are not removed. Not for commercial distribution or resale. For commercial use please contact us. All content of this website is copyright © 2011-2023 Calendarpedia®. All rights reserved. Data provided 'as is' without warranty and subject to error and change without notice.

Important note regarding paper size:
All templates downloadable below are in US letter paper size (8.5 by 11 inches - as used in the USA, Canada, Mexico, the Philippines and some South American countries). For templates in A4 paper size (the international standard paper size used in all other parts of the world) please see Calendarpedia's UK edition.

See also:

Other calendars for 2020:

Multi-year calendars for 2020:

Calendars 2020 in landscape orientation (9 templates)

File format: Excel (.xlsx)       Change to: Word (.docx)  ·  PDF
View large imageDownload Template 1: 2020 Calendar for Microsoft Excel (.xlsx file), landscape, 1 page, multi-colored
Template 1:
2020 Calendar
for Microsoft Excel (.xlsx file),
landscape, 1 page, multi-colored

Template 1:
Calendar 2020 for Excel
landscape, 1 page, multi-colored

  • yearly calendar for 2020 on 1 page, landscape orientation
  • each month in a different color ("rainbow calendar") to reflect the changing seasons
  • months horizontally (along the top), days vertically
  • US edition with federal holidays and observances
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel from version 2007 (.xlsx file)

Download template 1
View large imageDownload Template 2: 2020 Calendar for Microsoft Excel (.xlsx file), landscape, 1 page
Template 2:
2020 Calendar
for Microsoft Excel (.xlsx file),
landscape, 1 page

Template 2:
Calendar 2020 for Excel
landscape, 1 page

  • yearly calendar for 2020 on 1 page, landscape orientation
  • months horizontally (along the top), days vertically
  • US edition with federal holidays and observances
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel from version 2007 (.xlsx file)

Download template 2
View large imageDownload Template 3: 2020 Calendar for Microsoft Excel (.xlsx file), landscape, 2 pages, half a year per page
Template 3:
2020 Calendar
for Microsoft Excel (.xlsx file),
landscape, 2 pages, half a year per page

Template 3:
Calendar 2020 for Excel
landscape, 2 pages

  • yearly calendar for 2020 on 2 pages, landscape orientation
  • 6 months / half a year per page
  • months horizontally (along the top), days vertically
  • US edition with federal holidays and observances
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel from version 2007 (.xlsx file)

Download template 3
View large imageDownload Template 4: 2020 Calendar for Microsoft Excel (.xlsx file), landscape, 2 pages, days aligned, half a year per page
Template 4:
2020 Calendar
for Microsoft Excel (.xlsx file),
landscape, 2 pages, days aligned,
half a year per page

Template 4:
Calendar 2020 for Excel
landscape, 2 pages, days aligned

  • yearly calendar for 2020 on 2 pages, landscape orientation
  • days aligned horizontally (days of the week in the same row) for easy week overview
  • 6 months / half a year per page
  • US edition with federal holidays and observances
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel from version 2007 (.xlsx file)

Download template 4
View large imageDownload Template 5: 2020 Calendar for Microsoft Excel (.xlsx file), landscape, 4 pages, one calendar quarter per page
Template 5:
2020 Calendar
for Microsoft Excel (.xlsx file),
landscape, 4 pages,
one calendar quarter per page

Template 5:
Calendar 2020 for Excel
landscape, 4 pages

  • yearly calendar for 2020 on 4 pages, landscape orientation
  • months horizontally (along the top)
  • days vertically (down the side)
  • quarterly calendar - 3 months / one calendar quarter per page
  • US edition with federal holidays and observances
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel from version 2007 (.xlsx file)

Download template 5
View large imageDownload Template 6: 2020 Calendar for Microsoft Excel (.xlsx file), landscape, 1 page, linear
Template 6:
2020 Calendar
for Microsoft Excel (.xlsx file),
landscape, 1 page, linear

Template 6:
Calendar 2020 for Excel
landscape, 1 page, linear

  • linear calendar for 2020 on 1 page, landscape orientation
  • days aligned horizontally (days of the week in the same column)
  • months stacked above each other
  • for use as project timeline tracker
  • US edition with federal holidays and observances
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel from version 2007 (.xlsx file)

Download template 6
View large imageDownload Template 7: 2020 Calendar for Microsoft Excel (.xlsx file), landscape, 1 page, linear, days aligned
Template 7:
2020 Calendar
for Microsoft Excel (.xlsx file),
landscape, 1 page, linear, days aligned

Template 7:
Calendar 2020 for Excel
landscape, 1 page, linear, days aligned

  • linear calendar for 2020 on 1 page, landscape orientation
  • days aligned horizontally (days of the week in the same column)
  • months stacked above each other
  • days aligned (days of the week in the same column)
  • US edition with federal holidays and observances
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel from version 2007 (.xlsx file)

Download template 7
View large imageDownload Template 8: 2020 Calendar for Microsoft Excel (.xlsx file), landscape, 1 page, year at a glance, multi-colored
Template 8:
2020 Calendar
for Microsoft Excel (.xlsx file),
landscape, 1 page, year at a glance,
multi-colored

Template 8:
Calendar 2020 for Excel
landscape, year at a glance, 1 page, multi-colored

  • yearly calendar for 2020 on 1 page, landscape orientation
  • classic design annual planner
  • each month in a different color ("rainbow calendar") to reflect the changing seasons
  • US edition with federal holidays and observances
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel from version 2007 (.xlsx file)

Download template 8
View large imageDownload Template 9: 2020 Calendar for Microsoft Excel (.xlsx file), landscape, 1 page, year at a glance
Template 9:
2020 Calendar
for Microsoft Excel (.xlsx file),
landscape, 1 page, year at a glance

Template 9:
Calendar 2020 for Excel
landscape, 1 page, year at a glance

  • yearly calendar for 2020 on 1 page, landscape orientation
  • classic design annual planner
  • US edition with federal holidays and observances
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel from version 2007 (.xlsx file)

Download template 9
See also:

Calendars 2020 in portrait orientation (10 templates)

File format: Excel (.xlsx)       Change to: Word (.docx)  ·  PDF
View large imageDownload Download Excel template for 2020 calendar template 10: two half-year blocks on one page,<br>in color
Template 10:
2020 Calendar
for Microsoft Excel (.xlsx file),
portrait, 1 page, two half-year blocks,
multi-colored

Template 10:
Calendar 2020 for Excel
portrait, 1 page, two half-year blocks, multi-colored

  • two half-year blocks on 1 page, portrait orientation
  • each month in a different color ("rainbow calendar") to reflect the changing seasons
  • US edition with federal holidays and observances
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel from version 2007 (.xlsx file)

Download template 10
View large imageDownload Download Excel template for 2020 calendar template 11: two half-year blocks on one page
Template 11:
2020 Calendar
for Microsoft Excel (.xlsx file),
portrait, 1 page, two half-year blocks

Template 11:
Calendar 2020 for Excel
portrait, 1 page, two half-year blocks

  • two half-year blocks on 1 page, portrait orientation
  • US edition with federal holidays and observances
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel from version 2007 (.xlsx file)

Download template 11
View large imageDownload Template 12: 2020 Calendar for Microsoft Excel (.xlsx file), portrait, 1 page
Template 12:
2020 Calendar
for Microsoft Excel (.xlsx file),
portrait, 1 page

Template 12:
Calendar 2020 for Excel
portrait, 1 page

  • yearly calendar for 2020 on 1 page, portrait orientation
  • US edition with federal holidays and observances
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel from version 2007 (.xlsx file)

Download template 12
View large imageDownload Template 13: 2020 Calendar for Microsoft Excel (.xlsx file), portrait, 1 page, days aligned
Template 13:
2020 Calendar
for Microsoft Excel (.xlsx file),
portrait, 1 page, days aligned

Template 13:
Calendar 2020 for Excel
portrait, 1 page, days aligned

  • yearly calendar for 2020 on 1 page, portrait orientation
  • days aligned horizontally (days of the week in the same row) for easy week overview
  • US edition with federal holidays and observances
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel from version 2007 (.xlsx file)

Download template 13
View large imageDownload Template 14: 2020 Calendar for Microsoft Excel (.xlsx file), portrait, 2 pages, half a year per page
Template 14:
2020 Calendar
for Microsoft Excel (.xlsx file),
portrait, 2 pages,
half a year per page

Template 14:
Calendar 2020 for Excel
portrait, 2 pages

  • yearly calendar for 2020 on 2 pages, portrait orientation
  • 6 months / half a year per page
  • US edition with federal holidays and observances
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel from version 2007 (.xlsx file)

Download template 14
View large imageDownload Template 15: 2020 Calendar for Microsoft Excel (.xlsx file), portrait, 4 pages, one calendar quarter per page
Template 15:
2020 Calendar
for Microsoft Excel (.xlsx file),
portrait, 4 pages,
one calendar quarter per page

Template 15:
Calendar 2020 for Excel
portrait, 4 pages

  • yearly calendar for 2020 on 4 pages, portrait orientation
  • quarterly calendar - 3 months / one calendar quarter per page
  • US edition with federal holidays and observances
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel from version 2007 (.xlsx file)

Download template 15
View large imageDownload Download Excel template for 2020 calendar template 16: portrait orientation, 1 page, with US federal holidays and week numbers, days in continuous (rolling) layout
Template 16:
2020 Calendar
for Microsoft Excel (.xlsx file),
portrait, 1 page, continuous (rolling) layout

Template 16:
Calendar 2020 for Excel
portrait, 1 page, continuous (rolling) layout

  • full year 2020 on one page, portrait orientation
  • 1 column per weekday - good for planning repeating events
  • US edition with federal holidays and observances
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel from version 2007 (.xlsx file)

Download template 16
View large imageDownload Template 17: 2020 Calendar for Microsoft Excel (.xlsx file), portrait, 1 page, year at a glance, multi-colored
Template 17:
2020 Calendar
for Microsoft Excel (.xlsx file),
portrait, 1 page, year at a glance,
multi-colored

Template 17:
Calendar 2020 for Excel
portrait, 1 page, year at a glance, multi-colored

  • yearly calendar for 2020 on 1 page, portrait orientation
  • each month in a different color ("rainbow calendar") to reflect the changing seasons
  • US edition with federal holidays and observances
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel from version 2007 (.xlsx file)

Download template 17
View large imageDownload Template 18: 2020 Calendar for Microsoft Excel (.xlsx file), portrait, 1 page, year at a glance
Template 18:
2020 Calendar
for Microsoft Excel (.xlsx file),
portrait, 1 page, year at a glance

Template 18:
Calendar 2020 for Excel
portrait, 1 page, year at a glance

  • yearly calendar for 2020 on 1 page, portrait orientation
  • US edition with federal holidays and observances
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel from version 2007 (.xlsx file)

Download template 18
View large imageDownload Download Excel template for 2020 calendar template 19: portrait orientation, 1 page, with US federal holidays, observances, events, festivals and celebrations
Template 19:
2020 Calendar
for Microsoft Excel (.xlsx file),
portrait, 1 page, year at a glance,
with holidays, observances
and celebrations

Template 19:
Calendar 2020 for Excel
portrait, 1 page, with federal holidays, observances, festivals and celebrations

  • yearly calendar for 2020 on one page, portrait orientation
  • US edition with federal holidays, observances, festivals and celebrations
  • free to download, editable, customizable, easily printable
  • for Microsoft Excel from version 2007 (.xlsx file)

Download template 19
See also:

Other calendars for 2020:

Multi-year calendars for 2020:
Calendar templates
Home  ·  Sitemap / archive
Yearly calendars
Word: 2023  ·  2024   / 2025
Excel:  2023  ·  2024   / 2025
PDF: 2023  ·  2024   / 2025
Quarterly calendars
Word  ·  Excel  ·  PDF
Monthly calendars
Aug  ·  Sep  ·  Oct  ·  Nov  ·  Dec
Weekly calendars
Word: 2023  ·  2024   / 2022
Excel:  2023  ·  2024   / 2022
PDF: 2023  ·  2024   / 2022
Daily calendars
Word  ·  Excel  ·  PDF
Hourly calendars
Word  ·  Excel  ·  PDF
Split year calendars 23/24
Word  ·  Excel  ·  PDF
School calendars 23/24
Word  ·  Excel  ·  PDF
Academic calendars 23/24
Word  ·  Excel  ·  PDF
Fiscal calendars 2024
Word  ·  Excel  ·  PDF
2 year calendars 23/24
Word  ·  Excel  ·  PDF
3 year calendars 23-25
Word  ·  Excel  ·  PDF
Photo calendars 2024
Word  ·  Excel  ·  PDF
Birthday calendars
Word  ·  Excel  ·  PDF
Blank calendars
Word  ·  Excel  ·  PDF
Perpetual calendars
Word  ·  Excel  ·  PDF
Online Calendars
Yearly Calendars
2023  ·  2024  ·  2025   / 2022
US Federal Holidays
2023  ·  2024  ·  2025   / 2022
Planners
Hourly  ·  Daily  ·  Weekly  ·  Monthly  ·  Quarterly  ·  Yearly
Schedules
Hourly  ·  Daily  ·  Weekly  ·  Monthly  ·  Quarterly
More...
Leap years
When is...?
Sitemap (list of all templates)



If this site helps you please consider a donation to a charity of your choice:


Search this site: