Google Sheets calendar template: free file that updates for any year

The short answer: this free google sheets calendar template fills in its own dates: type a year in one cell, pick Sunday or Monday and all twelve month tabs redraw.

• Open it: upload to Google Drive and save as a Google Sheet
• Works in Excel too
• Cell B3 sets the year; B4 sets the week start
• A printed 2027 version if you want paper
• Next step: Get the free Google Sheets calendar template (we email it to you); want more? The Bill Tracker Spreadsheet is $4.99.

This free google sheets calendar template fills in its own dates. Type a year in one cell, pick Sunday or Monday as the first day of the week, and all twelve month tabs redraw. Upload it to Google Drive, save it as a Google Sheet and share it with your family, or open it in Excel. There's also a printed 2027 version if you just want paper.

What's in the free download

• The spreadsheet (.xlsx). A Start here tab with a year cell (B3) and a Sunday/Monday dropdown (B4), plus one tab for each month. Every date has three blank rows under it for events, and each month has a notes area.
• The 2027 printout (PDF). The same template printed for 2027, one landscape month per page.

The spreadsheet uses ordinary formulas (DATE, WEEKDAY and IF), with no macros, scripts or add-ons, so it works the same in Google Sheets and Excel.

How to open it in Google Sheets

The file downloads as an Excel file. Getting it into Google Sheets takes a minute. California College of the Arts' guide to Office files in Google Workspace lays out the steps:

1. Open Google Drive and choose New, then File upload.
2. Pick the .xlsx file you downloaded. Once it's uploaded, it shows up in your Drive.
3. Open it, then choose File, then Save as Google Sheets. Google creates a Sheets copy in a new tab, and both files stay in Drive.

If you ever need it back as an Excel file, choose File, then Download, then Microsoft Excel (.xlsx).

How to set the year and week start

Everything is driven by two cells on the Start here tab:

Change B3 to 2028 and January moves to start on a Saturday, February gets its 29th day and the rest follow. Switch B4 to Monday and the headings and dates shift one column.

How the date formulas work

Each month tab knows its own month number. For the first box in the grid, the formula finds the first day of the month, then steps back to the start of that week. Each box after that adds one day. A final check hides any date that belongs to the month before or after, so only the real dates show.

If you'd like to build your own, the core of it is:

• DATE(year, month, 1) for the first of the month.
• WEEKDAY(...) to find how many boxes to skip at the start.
• IF(MONTH(date)=month, DAY(date), "") to show the day number only when it belongs to this month.

That's why it works for any year, including leap years, without editing anything else.

Keep one copy per year

Events you type stay in their cell. If you change the year, the dates move but your notes don't, so a birthday typed under the 14th will end up under a different number. The fix is simple: when the year is done, use File, then Make a copy, and change the year in the copy. Your old year stays as a record. Name each copy with its year, such as "Family calendar 2027," so they're easy to find in Drive. It's also a quick way to look back at when last year's appointments, trips and school breaks happened when you plan the next year.

What to put on your spreadsheet calendar

Start with the dates that don't move. Kansas State University Extension's guide to managing time, work and family suggests listing inflexible activities, the ones that happen at set times, separately from flexible ones you can do whenever there's time. On a family calendar that means:

1. Holidays and school days off.
2. Paydays and bill due dates.
3. Birthdays and anniversaries.
4. Standing appointments like lessons, practices and meetings.
5. Travel and visits.

Then fill in flexible jobs around them. For a weekly view, Stanford's Center for Teaching and Learning suggests scheduling non-negotiables first, then regular commitments, then appointments, and leaving buffer time. Our weekly calendar page has a printable for that.

Tips for using it in Google Sheets

• Color-code people. Pick one fill color per family member and use it for their events.
• Share it. Use the Share button to give family members edit access so anyone can add an event.
• Use the phone app. The Google Sheets app lets you check and edit the calendar on the go.
• Freeze nothing. The months are built to fit on one screen and one printed page, so you won't need frozen rows.
• Add a comment to a cell for details like an address or a phone number, so the box stays tidy.

Google Sheets calendar vs Google Calendar

They do different jobs:

Many families use both: Google Calendar for alerts and the spreadsheet for planning a busy month, meals or bills. Our digital calendar guide compares the options in more detail.

Use it as a bill and payday calendar

A spreadsheet calendar is a handy place to see money dates. Write each bill on its due date and mark paydays, and you'll see quickly which weeks are tight. Our bill calendar guide shows how to set that up.

When you want the calendar to do the math too, the Bill Tracker Spreadsheet ($4.99) works in Excel and Google Sheets. Bills due in three days or less turn red, and a 12-month paid tracker shows what's been paid. The Annual Budget Spreadsheet ($6.99) covers the whole year: 12 monthly tabs, a transaction log with dropdowns, planned vs actual, over-budget alerts in red and a year dashboard with a chart.

If you budget every dollar, the Zero-Based Budget Spreadsheet ($6.99) is built for that method. For more on this topic, see our calendar templates hub.

Ideas for using the month tabs

Because each month has three writing rows under every date and a notes area at the bottom, the tabs work for more than appointments:

• Meal plan: one dinner per date, with the grocery list in the notes area.
• Chore rotation: a name under each date for that day's job.
• Habit tracker: an X under each day you walked, read or practiced.
• Activity schedule: practices and games in one color per child.
• Countdown: mark a trip or birthday and count the boxes left.
• Work shifts: start and end times under each date, with hours totaled in the notes.

Add your own extras

The template is a normal spreadsheet, so you can build on it:

1. Add a column for totals. Use column H, just right of the last weekday, for a weekly sum of hours or money.
2. Add a holiday list. Make a new tab with holiday dates for the year and copy them onto the month tabs.
3. Add conditional formatting. Highlight any cell that contains "bill" or "pay" so money dates stand out.
4. Duplicate a month tab if you want two copies, such as one for work and one for home.

Keep the formulas in the date rows as they are. If you type over one by accident, use Undo, or copy the formula from the box next to it and paste it back.

Troubleshooting

• A date shows as a long number. A cell was reformatted. Undo, or set the cell format back to Automatic.
• The month is blank. Check that B3 on the Start here tab has a four-digit year.
• The headings say Sun but you picked Monday. Make sure B4 says exactly "Monday," using the dropdown.
• It opens in Drive's preview. Use Open with, then Google Sheets, or follow the upload steps above.
• Printing spills onto two pages. Choose landscape and "fit to page" in the print settings.

Prefer paper?

If you'd rather print and write, the 2027 PDF in the download is ready to go. For an undated version you can number yourself, see our blank calendar template, and for a full year of dated pages, our 2027 calendar. The Household Binder ($6.99) has monthly calendar and weekly planner pages along with family info, meals, cleaning and bills, so the paper calendar lives with your other household records.