Skip to content
Yearly Calendar cover: a sample sheet with key dates in 2027, public holidays and deadlines still open and a bar chart, beside the Dashboard and Year grid tabs

Yearly Calendar

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Style
Minimal
Difficulty
Beginner
Updated
November 13, 2026

Every slide (5)

Overview

The Yearly Calendar is a one-page workbook for 2027 that shows all twelve months as rows and each day number as a column. Households, small teams and anyone planning their own year can tell at a glance which days are already taken. The Key dates tab holds holidays, deadlines, meetings, renewals and personal dates, each assigned to a person and given a status. The dashboard counts them by type and shows how many deadlines are still open.

Type a short label into any day of the Year grid, such as a trip or a bill due. Keep the Key dates list for anything that needs a named owner or a reminder. Print the grid on one landscape page and pin it up, then switch statuses to Done as dates pass. To roll the file forward to 2028, change the dates on the Key dates tab and leave the month labels as they are.

Useful for

  • Map holidays, school breaks and trips across the whole year
  • Track tax, renewal and insurance deadlines with a named owner
  • Pin a printed year view beside the desk for the family

What's included

  • 4 tabs: Dashboard, Year grid, Key dates, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Year grid: a grid
  • Key dates: a table
  • 1 chart that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Year grid tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

How do I add a date to the year view?

Type a short label into that day's box on the Year grid tab, such as Dentist or Flight out. If the date needs an owner or a status, add it to the Key dates tab too, because the dashboard only counts rows there.

Why does every month have 31 day columns?

The grid uses one column for each day number from 1 to 31, so short months leave the last columns empty. Leave those cells blank in February, April, June, September and November. The layout stays the same for every row, which keeps printing simple.

How do I print the calendar on one page?

Open the Year grid tab and choose File, then Print. Set the orientation to landscape and fit the sheet to one page wide. Check the preview first, since print settings look slightly different in Google Sheets and Excel.

  • #calendar
  • #yearly-calendar-2027
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More calendar templates

See all 510

Also in Business operations

All business operations templates
Get this template

Preparing your template…