FREE Monthly & Yearly Excel Calendar Template

I am a big fan of using Excel templates to plan and manage work.

I regularly use to-do lists and calendars to plan my days in advance.

In this post, I am sharing an Excel calendar template that you can use in Excel or even take a printout and stick it at home or at your workplace.

While it’s easy to create a static calendar in Excel, I have used the power of Excel formulas to create a dynamic calendar template that will update based on the selections you make.

It also makes it easy to quickly update the calendar and take a print if needed.

Click here to download the Excel Calendar Template.

Calendar Contemporary Digital Device Concepts

Monthly Excel Calendar Template

Below is the demo of the monthly calendar template (the download file has been updated for 2023):

Monthly Excel Calendar Template 2019 and 2020

You can specify the year in cell B1 and use the drop-down list in cell B2 to specify the month.

Based on it, the calendar automatically updates.

You can also specify the holidays in the backend, and it automatically gets highlighted in the calendar (as yellow boxes).

You can also print this monthly calendar and write notes, plans, or reminders below it. Alternatively, you can write down the notes in Excel and then take a print.

Click here to download the Excel Calendar Template.

Yearly Excel Calendar Template

Similar to the monthly calendar, there is also a yearly calendar (in a separate tab).

It’s a dynamic template, so you can enter the year number in cell B1, and it will automatically update the calendar for the specified year.

Yearly Excel Calendar Template Demo 2019 & 2020

You can specify the holidays in the template, and those days are automatically highlighted in the calendar.

The calendar has been made to fit in a single sheet when you print it. There is also some additional space below the calendar where you can write important notes.

Click here to download the Excel Calendar Template.

Print out of the calendar would look as shown below:

Yearly Excel Calendar Template 2019 & 2020 with Notes

Note that you can specify the holidays in the Holidays tab in the template.

Make sure that the date is entered in a format that Excel can understand as a date. For example, you can use the dd-mm-yyyy, or dd mm yyyy, or dd/mm/yyyy formats.

What goes into making this Excel Calendar Template?

For the Excel enthusiasts, here is what it took to make this calendar template in Excel:

  • Excel Formulas: This template used functions such as DATE, WEEKDAY, DAY, ISNUMBER, COLUMNS, and VLOOKUP.
  • Conditional Formatting: It is used to highlight the holidays in the calendar.
  • Drop-Down List: It is used to give an option to select the month in the monthly calendar.
  • Custom Number Formatting: It is used to show the numbers as months. For example, in the yearly calendar, The text January is actually number 1. Select cell B3 in the yearly calendar, and you will see that the formula bar shows 1. This number is shown as the month name using custom number formatting.

You May Also Like the Following Excel Templates:

Excel Ebook Subscribe

FREE EXCEL BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Picture of Sumit Bansal
Hello there! I'm Sumit Bansal, founder of trumpexcel.com and an Excel MVP. I started this website in 2013 with a simple goal: to share my love for Excel through easy to follow tips, tutorials and videos. I'm here to help you get the best out of MS Excel to save time and boost your productivity.

12 thoughts on “FREE Monthly & Yearly Excel Calendar Template”

  1. How about lenten holidays, ed’l ftir, eid adha, chinese new year, what syntax / function to be used. Tanx.

    Reply
  2. I’m from the US, and I’ve never seen or used a calendar that starts with Monday. I’m used to a calendar that starts with Sunday and ends with Saturday. Do you have a version of the calendar that is set up that way?

    Reply
  3. Assalamualaikum, Dear Brother Very Nice & Useful formula. Special thanks for ur effort & knowledge. Query if holidays show in the calender. thats will more better.

    Reply

Leave a Comment

Free-Excel-Tips-EBook-Sumit-Bansal-1.png

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Free-Excel-Tips-EBook-Sumit-Bansal-1.png

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster

Free Excel Tips EBook Sumit Bansal

FREE EXCEL E-BOOK

Get 51 Excel Tips Ebook to skyrocket your productivity and get work done faster