Free Yearly Calendar Template

We've created a free yearly calendar in Excel to add to our collection of calendar and scheduling templates. Each of the yearly calendars include 12 months on a single page, beginning with the year and month of your choice. They are easily customizable and there are no macros. See below for more details on the specific formats and styles.

For a ready-made 2013 yearly calendar in PDF format, see our new Free Printable Yearly Calendars.

Note: The screenshots below are just examples, created in 2012. That's why you'll see them also showing "2012" at the top. In the template, you can change the year to whatever year you want, including 2013.

2013 Yearly Calendar Collection

Download a free yearly calendar for Excel or OpenOffice from our collection listed below. Create and print yearly calendars for any year, starting with any month. These spreadsheets were designed to be simple to customize. They include the option of choosing Sunday-first or Monday-first, as well.

"No Installation, No Macros - Just Simple Spreadsheets"

Cost: Free ($0.00)
License: Personal Use Only (Applies to all the calendar downloads on this page).
Required: Microsoft Excel® 2000, 2002(XP), 2003, 2007, 2010, or OpenOffice

Screenshot	Yearly Calendar Template This basic perpetual yearly calendar lets you enter the year and starting month as well as select any day of the week as the first day. Yearly Calendar Template (.xls) Excel 2010 Version (.xlsx)   |   OpenOffice (.ods)
Screenshot Screenshot	Yearly Calendar with Notes (Landscape) 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) Excel 2010 Version (.xlsx)   |   OpenOffice (.ods) Yearly Calendar - Portrait (.xls) Excel 2010 Version (.xlsx)   |   OpenOffice (.ods)
Screenshot	Yearly Event Calendar This calendar is based on the Yearly Calendar Template above except that it also lets you enter dates for events and holidays into a list and the dates are automatically highlighted in the calendar via conditional formatting. Some US holidays and observances are included. Yearly Event Calendar (.xls) Excel 2010 Version (.xlsx)   |   OpenOffice (.ods)
Screenshot	Yearly Calendar with Week Numbers This version includes week numbers. Select between US or ISO week numbering. Yearly Calendar with Week Numbers (.xls) Excel 2010 Version (.xlsx)
Screenshot	Multiple-Year Calendar This spreadsheet includes four yearly calendars on a single page. Multi-Year Calendar (.xls) Excel 2010 Version (.xlsx)
Screenshot	Annual Calendar / Resolution Checklist This spreadsheet lists the days of the month by row in a linear format. Although it can be used for many different purposes, it was original created as a resolution checklist. Visit the Annual Calendar / Checklist page to download this template.
Screenshot	Annual Calendar - Vertical Print in landscape mode, with days of the week on the side and months listed across the top. Provides a column to write abbreviated events next to each date. Annual Calendar - Vertical (.xls) Excel 2010 Version (.xlsx)
	Full Year Calendar These spreadsheets contain one full year of monthly calendars (each month on a separate tab) as well as a yearly calendar. These files can be downloaded from the Calendar Template page.

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 2013-2014, 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 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).

Other Yearly Calendars

• Vertex42's Perpetual Calendar - This is one of our most recent creations, which combines the yearly event calendar with 12 monthly calendars, all in a single workbook.
• Business Card Calendar - Print a yearly calendar on the back of a business card.
• Yearly Calendar - TimeAndDate.com - This online (web-based) calendar lists holidays and other yearly events for any year that you specify.
• Printable Yearly Calendar - Paulding.net - This is another online calendar that lets you include a graphic at the top of the page. However, if you own Excel, you can do much more with an Excel yearly calendar template in terms of adding custom graphics.