Free Yearly Calendar Template

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

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

2009 Yearly Calendar Collection

	Download the free yearly calendar collection for Excel or OpenOffice. Create and print yearly calendars for any year, starting with any month. These spreadsheets were designed to be simple to customize. They include a Monday-first option, as well. "No Installation, No Macros - Just Simple Spreadsheets" Download for Excel  zipped .XLS (~400KB) Download for OpenOffice  zipped .ODS (~460KB) Cost: Free ($0.00) License: Personal Use Only Required: Microsoft Excel® 2000, 2002(XP), 2003, 2007, or OpenOffice The License and Requirements apply to all the calendar downloads on this page
Screenshot	Yearly Calendar Template A basic yearly calendar template without a Notes section. Yearly Calendar Template (.xls)
	Yearly Calendar with Notes If you would like a calendar with a Notes section, try one of the variations below, formatted in landscape or portrait orientation. Yearly Calendar - Landscape (.xls) Yearly Calendar - Portrait (.xls)
	Full Year Calendar These spreadsheets contain one full year of monthly calendars (each month on a separate tab) as well as a yearly calendar in landscape format. These are the same files contained within the Calendar Template download, but they are included here specifically because they work in OpenOffice and are part of the 2009 Yearly Calendar Collection. 2009 Calendar, 2010 Calendar, 2011 Calendar, 2012 Calendar (.xls)
	Yearly Calendar with Week Numbers This version includes week numbers. Select between US or ISO week numbering. Yearly Calendar with Week Numbers (.xls)
	Multiple-Year Calendar This spreadsheet includes four yearly calendars on a single page. Multi-Year Calendar (.xls)
	Annual Calendar / Checklist This spreadsheet lists the days of the month by row in a linear format. Originally created as a Resolution Checklist, but has many other uses, as well. Annual Calendar (.xls)

Yearly Calendar Features:

1) Choose the Year and the Starting Month

Enter the starting year and month at the top of the calendar. For example, if you are creating a yearly calendar for school year 2008-2009, you can start with month=8 (August). For those who use a fiscal year for their business planning, this yearly calendar is just right.

2) Sunday or Monday First

Much of the world uses a calendar that starts on Monday rather than Sunday. Our new yearly calendar (version 1.2.0) now includes this option.

3) Vertex42 Style

We enjoy making spreadsheets that are both simple, stylish, and user-friendly. Sometimes creating something with style requires us to use advanced features. For example, the yearly calendar template uses conditional formatting to make the blank cells light blue.

You can delete the conditional formatting if you want and add your own formatting to highlight specific dates in the calendar. To delete the conditional formatting, select all the cells in the calendar and go to Format > Conditional Formatting > Delete.

4) Changing the Calendar Color

Probably the easiest way to change the colors in your yearly calendar is to modify the color via the Color pallette (Tools > Options > Color tab).