Pro workbook: Week, Priorities, Review, Setup, Formulas. Sample data, real formulas.
| Weekly planner | ||||||||||
| Type any date and the week lays itself out. Yellow cells are yours; hours planned per day are counted. | ||||||||||
| Week of | 2026-09-16 | Day starts | 7:00 | Top three | Send the Grove proposal | First slot (h) | 7 | |||
| Starts | Mon 14 Sep | Slot | 1:00 | Ship v1.2 | Last slot ends (h) | 22 | ||||
| Three gym sessions | ||||||||||
| Time | Mon 14 Sep | Tue 15 Sep | Wed 16 Sep | Thu 17 Sep | Fri 18 Sep | Sat 19 Sep | Sun 20 Sep | Week | ||
| 7:00 | ||||||||||
| 8:00 | Plan the week | Writing | ||||||||
| 9:00 | Team standup | Deep work: report | Sprint review | Writing | Team standup | |||||
| 10:00 | Proposal draft | Deep work: report | Ship v1.2 | Market | ||||||
| 11:00 | Proposal draft | Deep work: report | Ship v1.2 | Family lunch | ||||||
| 12:00 | ||||||||||
| 13:00 | Client call: Harbor | |||||||||
| 14:00 | 1:1 with Sam | Interview | Hike | |||||||
| 15:00 | Dentist | Weekly review | ||||||||
| 16:00 | Admin, invoices | |||||||||
| 17:00 | Pick up parcel | |||||||||
| 18:00 | Gym | Gym | Gym | |||||||
| 19:00 | Dinner with Nora | Prep Monday | ||||||||
| 20:00 | ||||||||||
| 21:00 | ||||||||||
| Planned h | 6 | 5 | 4 | 4 | 5 | 2 | 2 | 28 | ||
| Free h | 9 | 10 | 11 | 11 | 10 | 13 | 13 | |||
| Fifteen slots from the start hour; change the start and the slot length on Setup and the times move. | ||||||||||
| Planned hours = filled slots × slot length. Weekends shaded, today blue. | ||||||||||
| To print: File → Print, landscape, fit to one page wide. |
| Priorities | ||||||
| Goals for the week. The first three show at the top of Week; ✓ when done. | ||||||
| # | Goal | Category | Done | Goals | 5 | |
| 1 | Send the Grove proposal | Work | ✓ | Done | 2 | |
| 2 | Ship v1.2 | Work | Progress | 40.0% | ||
| 3 | Three gym sessions | Health | ||||
| 4 | Book the Lisbon flights | Travel | ✓ | |||
| 5 | Read 100 pages | Personal | ||||
| Week in review | |||||||
| Planned hours per day, the busiest and lightest day, goals done — and two boxes to fill on Friday. | |||||||
| Day | Planned h | Free h | Share | Busiest day | Mon 14 Sep | ||
| Mon 14 Sep | 6 | 9 | 21.4% | Lightest day | Sat 19 Sep | ||
| Tue 15 Sep | 5 | 10 | 17.9% | Weekday average | 5 | ||
| Wed 16 Sep | 4 | 11 | 14.3% | Goals done | 2 of 5 | ||
| Thu 17 Sep | 4 | 11 | 14.3% | ||||
| Fri 18 Sep | 5 | 10 | 17.9% | ||||
| Sat 19 Sep | 2 | 13 | 7.1% | ||||
| Sun 20 Sep | 2 | 13 | 7.1% | ||||
| Week | 28 | ||||||
| What went well | Next week, first | ||||||
| Setup | ||
| The week, the day's span, and the goal categories. | ||
| Week of (any date) | 2026-09-16 | |
| Week starts on | Monday | |
| Day starts (hour) | 7 | |
| Slot length (hours) | 1 | 0.5 for half-hour slots; there are 15 slots |
| Categories | ||
| Work | ||
| Health | ||
| Personal | ||
| Family | ||
| Travel | ||
| How the formulas work | ||
| Every formula in this workbook, in plain words. Nothing is hidden and nothing needs a macro. Formulas are shown without the leading = sign. | ||
| Where | Formula | What it does |
| Week · starts | $B$3-WEEKDAY($B$3,IF(Setup!B4="Sunday",1,2))+1 | Any date snaps back to the start of its week. WEEKDAY type 2 makes Monday day 1; type 1 makes Sunday day 1. |
| Week · day header | $B$4+0 … +6 | Real dates, formatted 'ddd d mmm'. The weekend shading and today's highlight test these cells. |
| Week · time slot | $E$3+0*$E$4 | Start hour plus slot × length, as fractions of a day (7:00 is 7/24). Change either on Setup and the column moves. |
| Week · planned hours | COUNTA(B8:B22)*$E$4*24 | Filled slots times the slot length. Anything typed counts, so half-filled slots count as full — keep slots honest. |
| Week · free hours | 15*$E$4*24-B23 | The day's span minus what's planned. |
| Week · today / weekend | B$7=TODAY() · =WEEKDAY(B$7,2)>5 | Two conditional-format rules over the slot grid, anchored to the header row. |
| Priorities · progress | IF(G4=0,0,G5/G4) | Ticked goals over goals. COUNTA on the ✓ column — any mark counts. |
| Review · busiest day | INDEX(A5:A11,MATCH(MAX(B5:B11),B5:B11,0)) | The date whose planned hours equal the maximum. Ties go to the first. |
| Review · share | IF($B$12=0,0,B5/$B$12) | Each day's part of the week's planned hours. |