Bookmark and Share

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 2010 yearly calendar in PDF format, see our new Free Printable Yearly Calendars.

2010 Yearly Calendar Collection

Try our new Vertex42 Calendar Template on Google Docs!
2010 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, or OpenOffice
Excel Yearly Calendar Template
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.

Download the Yearly Calendar Yearly Calendar Template (.xls)  |  Download for OpenOffice (.ots)
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 for OpenOffice (.ots)

Download Yearly Calendar - Portrait (.xls)  |  Download for OpenOffice (.ots)

Yearly Event Calendar
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.

Download the Yearly Event Calendar Download for Excel (.xls)  |  Download for OpenOffice (.ots)
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 For Excel: 2010 Calendar, 2011 Calendar, 2012 Calendar

Try our Vertex42 Calendar Template on Google Docs!

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 2010-2011, 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.

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 Vertex42.com. If you have a website related to Excel or calendars (or both), we would appreciate a link to this page.

Thank you.

 

 

 

Become a Fan of Vertex42
Find Vertex42 on Facebook




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