Skip to content
Monthly Calendar cover: a sample sheet with events in january, open and done and a pie chart, beside the Dashboard, Month and Events tabs

Monthly 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 monthly calendar is for households and freelancers who want one page for a month of bills, tasks and appointments. The Month tab is a five-week grid from Monday to Sunday with the date in each cell, so you can write a short note beside any day. The Events tab logs every item along with its date, category, amount, status and a week number worked out from the date, and the dashboard counts events by category and by week.

The sample file covers January 2027 with twelve items, from rent and an electricity bill to a gym membership and a car service. Replace these with your own, then mark each item Done as you finish it. Check the week chart at the start of each Sunday, because a busy week often needs a short plan before it begins.

Useful for

  • Planning a month of bills, appointments and errands
  • Seeing which week of the month holds the most items
  • Tracking which tasks are still open before the month ends

What's included

  • 4 tabs: Dashboard, Month, Events, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Month: a grid
  • Events: a table
  • 2 charts 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 Month 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 change the month?

Change the dates on the Events tab and retype the dates in the Month grid. The week column recalculates from each date, so only the day labels in the grid need new values.

Why does the week number not match the calendar week?

The week column counts from the first of the month, so days 1 to 7 are week 1, days 8 to 14 are week 2 and so on. It is a month week rather than an ISO week number, so use it for planning the month rather than for payroll.

Can I add a recurring bill?

Copy the row for each month and change its date. Recurring items do not repeat automatically, so keep a list of regular bills on a separate tab if you have many.

  • #calendar
  • #monthly-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…