The free Excel Calendar Template on this page was one of the very first templates I created for Vertex42.com back in 2003. I've since added many other types of calendar templates, printable calendars, yearly calendars, planners, and schedules that you can find listed to the right. However, if you are looking for a professionally designed and easy-to-use 2016 or 2017 calendar template, go ahead and use the excel calendar template downloads on this page.

Advertisement

One of the great things about using an Excel calendar is the complete flexibility it gives you for entering events, highlighting cells, formatting, etc. It's kind of funny that a spreadsheet tool like Excel, originally created for accounting purposes, has turned into one of the most popular tools for creating custom calendars.

New!! Theme-Enabled Excel Calendar Templates

Theme-EnabledDownload Vertex42's new theme-enabled calendar templates! (for Excel 2007+)

Create great-looking calendars in seconds by just selecting the theme of your choice from Excel's gallery of colors and fonts (via the Page Layout tab).

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 2016 and Beyond!
Excel Calendar Template

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

Download
.xls files for multiple years
For: Excel 2003 or later
Download
Any Year Calendar
For: OpenOffice Calc

Other Versions

Template Details

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

Description

The zip download contains .xls versions of our full-year calendars for 2016 and 2017 through 2022. Each 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.

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.

How to Use this Calendar Template

The easiest files to use are the .XLSX downloads, and they need almost no explanation. If you want to use the older .xls files, then you need to download the .ZIP file and first extract the .xls files from the .ZIP archive. You can learn how to do that on the Support/FAQ Page.

These full-year calendar spreadsheets do not contain macros and there are no formulas to worry about. You can change formatting, add your own events, and otherwise modify the calendar without having to worry about messing up the dates.

Other Free Excel Calendars

Related Content