Free Excel Yearly Calendar Template

We have created a free yearly calendar in Excel to add to our collection of calendar and scheduling templates. This spreadsheet will show 12 months on a single page, beginning with the month and year of your choice. It is easily customizable and there are no macros. See below for more details. We list other free yearly calendars at the bottom of this page.

For a ready-made 2007, 2008, 2009, or 2010 yearly calendar in PDF format, see our new Free Printable Yearly Calendars

This template uses Excel's built-in form controls, so there are no macros that tend to make many other spreadsheets difficult to customize.

We enjoy making spreadsheets that are both simple, stylish, and user-friendly. This template definitely fits that category. It uses conditional formatting to make the blank cells gray and shadow boxes to help give the calendar some life.

If you don't want the shadow boxes (which the yellow arrow in the figure above is pointing to), then go ahead and delete them. You can delete the conditional formatting if you want and add your own formatting to highlight specific dates. Have fun!

You are not limited to just a single year with this spreadsheet. Additional months can be added by just copying and pasting. The formulas use the number in the upper right corner of the calendar to specify the month. (eg. The number "1" near the yellow arrow in the figure above)

For those who like to use fiscal years for your calendars, this one is just right. You can begin the yearly calendar with any month.

If you like this Excel template, please just tell your friends and coworkers about it. If you have a website related to Excel or calendars (or both), we would appreciate a link to this page, and don't hesitate to add your links to our Excel portal.