Our free yearly calendar templates for Excel are extremely easy to use, customize, and print. Each of the yearly calendars include 12 months on a single page, beginning with the year and month of your choice. They are easy to edit and do not use macros. If you need to create a calendar for your home, school, club, business, or other organization, take a look at the many formats and styles we offer below. For a printable 2014 or 2015 yearly calendar in PDF format, see our Printable Calendars.

Advertisement

2014/2015 Yearly Calendar Collection

Theme-Enabled for Excel 2007+
Theme-enabled Yearly Calendars

Create and print yearly calendars for any year, starting with any month or day of the week (Sunday-first or Monday-first). The new .XLSX versions for Excel 2007 or later are theme-enabled, meaning that you can choose a different color scheme by just going to Page Layout > Colors.

"No Installation, No Macros - Just Simple Spreadsheets"

License: Personal Use (Applies to all the calendar downloads on this page). You may print as many paper copies of these calendars as you need.

Yearly Calendar Template

Classic Design
Excel Yearly Calendar Template
Screenshot

Yearly Calendar (Portrait)

This perpetual yearly calendar lets you enter the year and starting month as well as select any day of the week as the first day.

You can download it for either Excel 2003, Excel 2007+, or OpenOffice.org. Three other designs are available for Excel 2007 or later.

Chamfer Design
2014 Yearly Calendar Template (Chamfer theme)
Screenshot
Light Design
2014 Yearly Calendar Template (Light theme)
Screenshot
Bold Design
2014 Yearly Calendar Template (Bold theme)
Screenshot

Advertisement

Yearly Calendar Template in Landscape Orientation

Classic Design
Yearly Calendar Template (Landscape Orientation)
Screenshot

NEW Yearly Calendar Template (Landscape)

If you are looking for a calendar that you can print and use for reference, and don't care about including a list of dates and events on your calendar, this template may be just the thing. It uses the entire piece of paper to show one year.

These templates are the landscape versions of the ones above.

Chamfer Design
Yearly Calendar Template (Chamfer theme)
Screenshot
Light Design
Yearly Calendar Template (Light theme)
Screenshot
Bold Design
Yearly Calendar Template (Bold theme)
Screenshot

Calendar Year with Notes

Classic Design
Yearly Calendar - Portrait
Screenshot

Yearly Calendar with Notes (Portrait)

When you are using a calendar for planning, it is helpful to make a list of important events. This template lets you add the date and descriptions for birthdays, anniversaries, etc.

Chamfer Design
2014 Yearly Calendar Template (Chamfer theme)
Screenshot
Light Design
2014 Yearly Calendar Template (Light theme)
Screenshot
Bold Design
2014 Yearly Calendar Template (Bold theme)
Screenshot

Calendar Year with Notes - Landscape

Classic Design
Yearly Calendar - Landscape
Screenshot

Yearly Calendar with Notes (Landscape)

If you are creating a calendar for an organization or to plan your family's vacation(s) this year, you will want a place to list important events. The Notes area to the side of this template allows you to make a list of specific events.

These templates are the landscape versions of the ones above.

Chamfer Design
Calendar Year (Chamfer design)
Screenshot
Light Design
Calendar Year (Light design)
Screenshot
Bold Design
Calendar Year (Bold design)
Screenshot

Yearly Photo Calendars

Classic Design
Yearly Photo Calendar
Screenshot

NEW: Yearly Photo Calendar Template

Photo calendars are fun. They are also useful for promoting your service business. This template lets you include a photo, logo, or other image above the calendar.

This template is available in four different designs, for Excel 2007 or later. All of them are theme-enabled, so you can easily change the colors.

Check out our other monthly photo calendars.

Chamfer Design
Yearly Photo Calendar (Chamfer theme)
Screenshot
Light Design
Yearly Photo Calendar (Light theme)
Screenshot
Bold Design
Yearly Photo Calendar (Bold theme)
Screenshot

Yearly School Calendars

Classic Design
Yearly School Calendar
Screenshot

NEW 2014-2015 Yearly School Calendar Template

All of our new theme-enabled calendar templates let you choose the start month, so even though all of them can be used to create a school year calendar, this design is particularly popular for schools. You can include the name of your school at the top and list the important events in the center.

Chamfer Design
Yearly School Calendar (Chamfer theme)
Screenshot
Light Design
Yearly School Calendar (Light theme)
Screenshot
Bold Design
Yearly School Calendar (Bold theme)
Screenshot

More Yearly Calendars

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.

Yearly Calendar with Week Numbers
Screenshot

Yearly Calendar with Week Numbers

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

Multi-Year Calendar Template
Screenshot

Multiple-Year Calendar

This spreadsheet includes four yearly calendars on a single page.

Annual Calendar - Vertical
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.

Full Year Calendar

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.

Still More Yearly Calendar Templates


This spreadsheet lists the days of the month by row in a linear format. Works grest for use as a daily checklist.
Create a fiscal year calendar for any year and start date. The default uses Oct 1st for the U.S. government fiscal year.
This spreadsheet includes 4 different designs for printing a 3-year calendar on a single page.
This spreadsheet uses a yearly calendar to make a list of birthdays to use as a reminder.
Print a simple birthday reminder calendar for listing birthdays for your family, class, or office.
This yearly planning calendar has space below to write brief notes below each day.

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 2014-2015, 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 palette (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.
  • Calendars with Holidays - TimeAndDate.com - This online (web-based) calendar lists holidays and other yearly events for any year that you specify.

 

Like This Template?

Become a Fan

       
Master Excel - Spreadsheet Tips Workbook