Planning template
Year at a glance calendar
A full year calendar drawn by formulas from a single year input. Weekends are tinted and today is highlighted.
- Free
- No account needed to try
- Download as .xlsx
What's inside
Everything is a normal workbook once you open it: change the numbers, rename the sheets and make it yours.
1 sheet
- Calendar
27 formulasTotals, lookups and checks are already worked out, so the sheet updates as you type. 118 filled cells in all.
Built in
- Conditional formatting
- Named ranges
- Dynamic arrays
- Live dates
- 24 conditional format rules
A look at the Calendar sheet
The top left of the first sheet, calculated by SheetsBat. Open the template to see all of it.
| A | B | C | D | E | F | G | H | |
|---|---|---|---|---|---|---|---|---|
| 1 | Year at a glance | |||||||
| 2 | Change the year and every month redraws. | |||||||
| 3 | Year | 2026 | ||||||
| 4 | ||||||||
| 5 | January | |||||||
| 6 | S | M | T | W | T | F | S | |
| 7 | 1 | 2 | ||||||
| 8 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | |
| 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | |
| 10 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | |
| 11 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | |
| 12 | 31 | |||||||
- calendar
- year
- dates
- planner
More planning templates
PlanningEvent budgetBudget a party, launch or conference with estimates, actual costs and payments to vendors. See the cost per guest and what is still owed.
PlanningWedding plannerKeep the wedding budget, guest list and checklist in one place. RSVP and meal counts, spending by category and due dates update as you go.
PlanningWeekly scheduleLay out a week hour by hour from 7 am to 8 pm. Dates fill in from the start date and booked and free hours are counted per day.
PlanningDaily plannerPlan a single day with top priorities, an hour by hour schedule, a to do list and notes. Progress fills in as you tick things off.
Start your year at a glance calendar now
It opens in your browser in a second. Create a free account to save it, share it and open it anywhere.