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

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"

Yearly Calendar for Excel Download for Excel  zipped .XLS (~400KB)

Yearly Calendar for OpenOffice 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

Excel Yearly Calendar Template
Screenshot

Yearly Calendar Template

A basic yearly calendar template without a Notes section.

Download the Yearly Calendar Yearly Calendar Template (.xls)
Yearly Calendar - Landscape

Yearly Calendar - Portrait

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.

Download Yearly Calendar - Landscape (.xls)

Download Yearly Calendar - Portrait (.xls)

Annual Calendar / Checklist

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.

Download 2009 Calendar, 2010 Calendar, 2011 Calendar, 2012 Calendar (.xls)

Yearly Calendar with Week Numbers

Yearly Calendar with Week Numbers

This version includes week numbers. Select between US or ISO week numbering.

Download Yearly Calendar with Week Numbers (.xls)

Yearly Calendar with Week Numbers

Multiple-Year Calendar

This spreadsheet includes four yearly calendars on a single page.

Download Multi-Year Calendar (.xls)

Annual Calendar / Checklist

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.

Download 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.

One month in the yearly calendar
One Month in the Yearly Calendar.

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).

Instead of Paying For This Yearly Calendar ...

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.

 

 

 

Add a Button to Your Toolbar
Add a Calendar Button
to your Google Toolbar