The easiest way to create a calendar in Excel is to use a professionally designed template. The free Excel Calendar Template on this page was one of my first and most popular templates. It is easy to use and includes useful features like common holidays, mini previous/next month calendars, and highlighted weekends. We have since created many other types of calendar templates, printable calendars, yearly calendars, planners, and schedules that you can find listed to the right.


One of the reasons many people prefer using an Excel calendar over other calendar software is the flexibility a spreadsheet gives you when entering events, highlighting cells, formatting, etc. Excel, originally created for accounting purposes, has turned into one of the most popular tools for creating custom calendars.

Theme-Enabled Excel Calendar Templates

Theme-EnabledCreate great-looking calendars in seconds by selecting the theme of your choice from Excel's gallery of colors and fonts via the Page Layout tab (Themes require Excel 2007 or later).

Learn more about Theme-Enabled Templates

All of the calendars shown in the image to the right were created by just modifying the theme.

More designs for our theme-enabled calendar templates

Excel Calendar Template

The Original - over 2.5 million downloads - For 2018 and Beyond!
Excel Calendar Template

For the newer Excel XLSX versions, use the download links listed above.

Other Versions

License: Personal Use
View Agreement (not for distribution or resale)


Each of the Excel files includes a yearly calendar worksheet followed by 12 monthly calendars on separate worksheets. There are no complicated formulas in these files, so you can easily add events, birthdays, anniversaries and holidays, to create calendars for your family, club, or organization. Some U.S. holidays and observances are already included.

These full-year calendar spreadsheets do not contain macros. You can change formatting, merge cells to create events spanning multiple days, and otherwise modify the calendar without having to worry about messing up the dates.

The screenshot on the left shows what our original free calendar template looked like. Before Excel 2007 came out with a good color palette, we used macros within the template to generate good color schemes for our calendars. Now, you can download the theme-enabled versions listed above if you want a way to easily pick different colors for your calendar.

We've created many different calendar templates since this original one. so if you are looking for something more perpetual, you can try our new Calendar with Holidays, or the Perpetual Calendar.

Other Free Excel Calendars

How to Make a Calendar in Excel using Built-In Templates

To use one of the calendar templates from the Microsoft template gallery, follow these steps after opening Excel:

  1. Go to File > New
  2. Look for a calendar in the featured set of templates or enter "calendar" in the search field.
  3. Click on the template thumbnail to preview or open directly in Excel.

Related Content



Follow Us On ...

Debt Snowball Calculator by

Sponsored Listings