Weekly Planner Template for Excel: Time Blocks, Priorities and Hours by Category
Create a weekly planner template in Excel or Google Sheets: auto-updating dates, hourly time blocks, color-coded categories, top-three priorities, daily task lists, hours by category and a printable one-page layout, with an example week.
A weekly planner template in Excel is a one-page grid with the seven days across the top and time slots down the side, plus a box for the week’s top priorities and a short task list per day; you assign each time block to a category (deep work, meetings, admin, exercise, family) and the sheet colors the blocks and totals the hours you’ve planned for each. Change one cell — the Monday date — and every date updates for the new week. It turns a long to-do list into a realistic plan for when things will actually happen.
This guide belongs to our Daily & Weekly Planners section. Keep your master list of tasks in a to-do list template; the weekly planner decides when you’ll do them.
What goes on the page
| Block | Cells | Purpose |
|---|---|---|
| Week start | B1 | The Monday of the week — the only date you type |
| Day headers | C3:I3 | Dates Monday–Sunday |
| Time slots | B4:B17 | Hourly from 7:00 to 20:00 (or 30-minute slots if you prefer) |
| Time-block grid | C4:I17 | Category or activity per slot |
| Top 3 priorities | K3:K5 | What would make this week a success |
| Daily tasks | C20:I25 | Three to six tasks under each day |
| Hours summary | K8:L15 | Planned hours per category and unscheduled time |
| Lists sheet | — | Categories for the dropdown |
Formulas
Dates that update themselves
- Monday of the current week in B1:
=TODAY()-WEEKDAY(TODAY(),2)+1(or type the Monday you’re planning). - C3:
=$B$1; D3:=C3+1, copied to I3. - Readable headers:
=TEXT(C3,"ddd m/d")shows “Mon 11/9”. - Week number for the title:
="Week "&ISOWEEKNUM(B1).
Time slots
Type 7:00 in B4, then in B5 use =B4+TIME(1,0,0) and copy down. For 30-minute slots, use TIME(0,30,0) and remember each cell is then half an hour.
Category dropdown and colors
Select C4:I17 → Data → Data Validation → List, source =Lists!$A$2:$A$8. Then add conditional formatting rules with formulas like =C4="Deep work" (blue), =C4="Meetings" (orange), =C4="Exercise" (green). Keep colors light so text stays readable when printed.
Hours by category
- Week total for a category:
=COUNTIF($C$4:$I$17,K8)(multiply by 0.5 if you use 30-minute slots). - One day only:
=COUNTIF(C$4:C$17,$K8). - Unscheduled time:
=COUNTBLANK($C$4:$I$17).
Example week: November 9–15, 2026
A freelancer plans 7:00–21:00 in hourly blocks: 14 slots a day, 98 hours on the page.
| Category | Hours planned | Where they sit |
|---|---|---|
| Deep work | 16 | Mon–Thu, 9:00–13:00 |
| Meetings | 6 | Tue and Thu afternoons, batched |
| Admin and invoicing | 4 | Fri 14:00–18:00 |
| Exercise | 4 | Mon, Wed, Fri at 7:00; Sat morning |
| Learning | 2 | Wed 16:00–18:00 |
| Errands | 3 | Sat |
| Family and personal | 22 | Evenings and Sunday |
| Total planned | 57 | |
| Unscheduled | 41 | Buffer, meals, rest |
Top three priorities: send the proposal to the new client, finish October invoicing, outline the workshop. Each one has at least one block on the grid — a priority with no block usually doesn’t happen. The figures are an example; your categories and hours will differ.
How to plan your week in 20 minutes
- Look back: what slipped last week, and why?
- Pick three priorities. Not ten.
- Place fixed commitments first: meetings, appointments, school runs, shifts.
- Block time for priorities in your highest-energy hours.
- Batch small tasks (email, calls, invoices) into one or two blocks.
- Leave buffer. A week planned to 100% breaks at the first surprise; 20–40% unscheduled is normal.
- Check Friday: compare planned vs. actual hours in each category and adjust next week.
Variations
| Version | What changes | Good for |
|---|---|---|
| Task-only weekly planner | No time grid; just priorities and tasks per day | Flexible schedules, students |
| Work-week planner | Monday–Friday only, 30-minute slots | Office and client work |
| Family planner | One column per family member instead of per day, plus a weekly meal row | Shared household schedules |
| Shift planner | Rows are employees, columns are days | Teams — use the employee schedule template |
Printing a one-page planner
- Page Layout → Orientation → Landscape.
- Set the print area to A1:L25.
- Scaling: Fit Sheet on One Page.
- Add the week title in the header with the ISOWEEKNUM formula above.
Print Monday’s plan, keep it on your desk, and update the sheet on Friday — or keep it fully digital in Google Sheets on your phone.
Common mistakes
- Scheduling every hour — no room for reality.
- Free-typed categories — “Admin” and “admin ” count separately; use the dropdown.
- Planning without priorities — the grid fills with busywork.
- Skipping the Friday review — the planner never improves.
- Overwritten date formulas — protect them as shown in how to protect formulas in Excel.
Add one row at the bottom for daily habits if you like, or keep them in a separate habit tracker.
FAQ
Should I use hourly or 30-minute slots?
Hourly slots keep the page readable and are enough for most people. Use 30-minute slots if your days are full of short meetings or calls.
How do I keep past weeks?
Duplicate the sheet each week and change the Monday in B1. A summary sheet can total hours per category across weeks with SUMIF.
Does the template work in Google Sheets?
Yes. TODAY, WEEKDAY, TEXT, ISOWEEKNUM, COUNTIF, COUNTBLANK, data validation and conditional formatting all work in Google Sheets.
Is a weekly planner better than a calendar app?
They complement each other. Calendar apps are best for appointments and reminders; a weekly planner sheet shows the whole week’s balance at a glance and totals your hours by category.
Next step: create the Lists sheet with your categories, build the grid and plan next week starting with your top three priorities. More planners are in Printable Planners & Forms.