Free Google Sheets Calendar Template 2026
Every date cell is a formula based on the first day of the month, so the grid always lines up with the right weekday. The sample shows January 2026; switch it to any month with one find-and-replace.
What it looks like
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Week | Mon | Tue | Wed | Thu | Fri | Sat | Sun |
| 2 | 1 | 29 | 30 | 31 | 1 | 2 | 3 | 4 |
| 3 | 2 | 5 | 6 | 7 | 8 | 9 | 10 | 11 |
| 4 | 3 | 12 | 13 | 14 | 15 | 16 | 17 | 18 |
| 5 | 4 | 19 | 20 | 21 | 22 | 23 | 24 | 25 |
| 6 | 5 | 26 | 27 | 28 | 29 | 30 | 31 | 1 |
What's included
- Monday-first weeks, with the trailing days of the previous month filled in
- Dates calculated with DATE and WEEKDAY, so they never drift
- Switch months by replacing one value
- Plenty of room to add events under each date row
How to set up the calendar template 2026
- 1.Download the CSV and import it into Google Sheets.
- 2.To show another month, press Ctrl+H and replace DATE(2026,1,1) with, for example, DATE(2026,2,1). Tick "Also search within formulas".
- 3.Insert a blank row under each week to write events and deadlines.
- 4.Use Format → Conditional formatting to grey out days that belong to the previous month.
- 5.Duplicate the tab twelve times for a full year.
Questions
- Does it work for 2027?
- Yes. Replace 2026 with 2027 inside the DATE formulas and the grid recalculates.
- Can I start the week on Sunday?
- Change WEEKDAY(…,2) to WEEKDAY(…,1) in the formulas and rename the column headers to start with Sun.
More templates
Weekly Schedule Template
An hour-by-hour weekly schedule for Google Sheets that counts how many hours you've booked each day.
Get the templateHabit Tracker
A weekly habit tracker for Google Sheets with checkboxes and a completion rate for each habit.
Get the templateProject Management Template
A lightweight task tracker for Google Sheets with owners, priorities, due dates and overall progress.
Get the template