PLANNERS & PRODUCTIVITY
Editable Calendar Spreadsheet for Any Year
CA$18 one-time price
- Microsoft Excel 2016 or later, Windows and Mac
- Google Sheets, free with a Google account
- Light edition
- Worked example + blank copy, with an instruction guide
- Instant download right after payment, on screen and by email
- Pay once, keep it forever. No subscription
- No macros, no add-ins, no bank connection
About this template
This editable calendar works for any year from a single cell. Type the year and all twelve months redraw with every date, weekday and leap day in the right place. It is for anyone who wants a calendar template they can print or type into, and keep using next year without buying it again.
Please read: This is a tracker tool only, not financial, tax, legal, medical or any other professional advice or advisory service. It records and calculates what you enter; you are solely responsible for checking all figures, rates, dates and results and for every decision you make. By purchasing, downloading or using it, you accept these terms (your statutory consumer rights are not affected).
One year cell
Most calendar templates have the year typed into the cells, which is why so many are sold as a new edition every year. Here every date comes from one cell on Setup. Change it and the whole yearly calendar follows, so next year is not a new purchase. In that sense it is a perpetual calendar.
It knows which day the 1st falls on
Every month grid is built with date arithmetic, so nothing is hardcoded and nothing has to be checked by hand.
- A month starting on a Sunday lays out correctly
- February is right in a leap year
- The 1st lands on the right weekday, every month, every year
Twelve months on one page
- Twelve month grids on a single page
- A printable calendar as it stands, or type into any date
- Use it as a monthly planner for appointments, birthdays and plans
A planner behind it
The calendar is attached to something, so it is more than a picture of a year.
- Tasks: 250 tasks by area and priority
- Today, assembled from your tasks
- A dashboard reading all of it
The six connected tabs are Start Here, Setup, Calendar, Tasks, Today and Dashboard. The Start Here tab walks you through setup in a few minutes.
Works with
- Microsoft Excel 2016 or later, on Windows or Mac
- Google Sheets with a free Google account. The Google Sheets version is a real workbook you take a copy of, not a PDF with a link in it.
- No dynamic arrays, no macros and no add-ins, so it behaves the same on Excel 2016, 2019, 2021 and Microsoft 365 and in LibreOffice. No Microsoft 365 subscription is required.
- No subscription
What you download
- Two Excel files: this year drawn from the one cell, and a blank one ready for yours
- The instruction guide, which has one-click links to the Google Sheets versions (filled and blank)
- The terms of use as a PDF
Your files are ready to download as soon as payment clears. The file is for your personal use, so please do not share or resell it. Questions before or after you buy? Use our contact page and we will help.
Frequently asked questions
Does it work in Excel or Google Sheets?
Both. The Excel files run on Excel 2016 or later on Windows or Mac, and the instruction guide has one-click links to make your own copy of the Google Sheets versions.
Can I use it again next year?
Yes. Change the year in one cell and all twelve months redraw for the new year.
Does it handle leap years?
Yes. Every date is calculated, so February is correct in a leap year and each month starts on the right weekday.
Can I print it?
Yes. The twelve months sit on one page and print as they stand, or you can type into any date first.
Is there more than the calendar?
Yes. It includes a Tasks tab with 250 tasks by area and priority, a Today tab and a dashboard.
