Weekly Planner Google Sheets Template, Cell By Cell

You don't need to download a weekly planner Google Sheets template. You need about fifteen formulas, and every page ranking for this search hides them inside a file you have to copy. So here they are, printed, with the cell each one goes in.

The build is two tabs. A Week tab with a time grid that draws itself from one date cell and highlights today, and a Tasks tab with checkboxes, a weekday dropdown and a due date, feeding a five-line summary and a per-day list of what's still open. About ten minutes to type in. Nothing to install, nothing to buy, and it works on the free Google account you already have.

Every function and menu path below is checked against Google's own Docs Editors Help, loaded on 15 September 2026. I haven't run it past a hundred users. I've checked each formula against the documented syntax and I'll tell you which two are the ones that break when people retype them.

What The Downloads Actually Give You

The number one result for this query is a Google Sheet, which sounds ideal until you open it. It's view-only, published by Smartsheet, with three input cells and the note "Edit these fields only. Date and time will populate automatically." The example week starts on 5/1/17. The interval defaults to ten minutes, so 2:50 PM lands on row 54 and the working day scrolls. Row 56 is an advert.

The formulas driving it can't be seen from outside an account, which is the pattern on the whole page. Smartsheet's own article describes eight templates and prints no formula. Toggl's tells you to change cell C4. The only page that shows any formula at all is a build guide that ends by selling an AI agent platform, and the formulas it shows are the completion percentage, not the grid.

I'd rather you saw the whole thing. A template you can read is one you can fix.

The Two Tabs, Cell By Cell

Rename the first tab Week and add a second tab called Tasks. The names matter because the formulas reference them.

On the Week tab, A1 holds the label "Week of" and B1 holds the Monday. C1 holds the label "Weeks ahead" and D1 holds a zero. Row 3 is the header row, with "Time" in A3 and the seven dates in B3 to H3. A4 down to A28 is the time column, 7:00 to 19:00 in half hours. B4 to H28 is the grid you type into. J3 to K7 is the summary. Row 30 under each day is where that day's open tasks appear.

On the Tasks tab, row 1 holds five headers, Done, Task, Day, Due and Minutes, in A1 to E1. Rows 2 to 60 are the list.

Now the formulas.

Week!B1     =TODAY()-WEEKDAY(TODAY(),2)+1+7*$D$1
Week!B3     =$B$1
Week!C3     =B3+1        (copy across to H3)
Week!A4     =TIME(7,0,0)
Week!A5     =A4+TIME(0,30,0)        (copy down to A28)

Week!K3     =COUNTIF(Tasks!A2:A60, TRUE)
Week!K4     =COUNTIFS(Tasks!A2:A60, FALSE, Tasks!B2:B60, "<>")
Week!K5     =COUNTIFS(Tasks!A2:A60, FALSE, Tasks!B2:B60, "<>", Tasks!D2:D60, "<"&TODAY())
Week!K6     =SUMIF(Tasks!A2:A60, FALSE, Tasks!E2:E60)
Week!K7     =IFERROR(K3/(K3+K4), 0)

Week!B30    =IFERROR(FILTER(Tasks!$B$2:$B$60, Tasks!$C$2:$C$60=TEXT(B$3,"ddd"), Tasks!$A$2:$A$60=FALSE), "")
            (copy across to H30; leave rows 31 to 40 empty)

Conditional formatting, Week tab, range B3:H28, custom formula:
            =B$3=TODAY()
Conditional formatting, Week tab, range B4:H28, custom formula:
            =AND(B$3=TODAY(), NOW()-TODAY()>=$A4, NOW()-TODAY()<$A4+TIME(0,30,0))

Conditional formatting, Tasks tab, range A2:E60, custom formula:
            =$A2=TRUE
Conditional formatting, Tasks tab, range A2:E60, custom formula:
            =AND($A2=FALSE, $B2<>"", $D2<>"", $D2<TODAY())

Labels for J3 to J7 are just text, Done, Open, Overdue, Minutes left, Done %. Format K7 as a percentage.

That's the whole template. The rest of this piece is why each part is built the way it is, because that's what lets you change it.

Why The Week Comes From One Cell

The first formula is the one that makes this a planner rather than a grid. WEEKDAY with a type of 2 counts from Monday, so Google's help says Monday returns 1 and Sunday returns 7. Subtract that from today and add one and you're on this week's Monday whatever day you open the sheet. The 7 times D1 at the end lets you type 1 into D1 to look at next week and 0 to come back.

If you'd rather fix the week, type a date into B1 instead. Type an actual date, though. Google's WEEKDAY page has a warning worth knowing for the whole sheet, that a literal like 10/10/2000 typed inside a formula is read as ten divided by ten divided by two thousand. A date in a cell is fine. A date inside a formula needs DATE(2026,10,12).

The header dates in row 3 are plain arithmetic on B1, and the ddd d mmm format is what turns a plain date into Mon 12 Oct. They stay real dates underneath, which is what the today-highlight and the per-day filter both depend on. If you type the day names as text instead, both of those stop working, and that's the first of the two places retyping usually goes wrong.

Why Rollover Is Free

Templates that promise "automatic rollover" usually need a script. This one doesn't, because the per-day list keys on the weekday, not the date.

The filter in row 30 shows every task whose Day column matches the short name of the date above it and whose checkbox is unticked. TEXT with the ddd pattern gives the short weekday name, per Google's documentation, so a date of 12 October 2026 becomes Mon, and it matches the dropdown value Mon. When Monday passes and the task isn't done, it's still Mon, so next Monday it's still there. Nothing to run.

The cost of that is a task can roll forever without anyone noticing, which is what the Due column and the Overdue count are for. K5 counts open tasks whose due date is before today, using the "<"&TODAY() pattern that Google's own COUNTIFS examples use for dates. The overdue rule on the Tasks tab turns those rows red. So the week view is forgiving and the task list isn't, which I think is the right way round.

One detail that trips people up. TEXT's short weekday names follow the spreadsheet's language setting. If your sheet is set to something other than English, check what B3 shows once it's formatted and use those spellings in the dropdown. That's the second place retyping goes wrong.

Why The Highlights Live Where They Do

Google's conditional formatting help has a note that explains a lot of broken templates. "Formulas can only reference the same sheet." A rule on the Week tab can't look at the Tasks tab directly, which is why the today-highlight and the current-slot highlight sit on Week and read Week's own row 3 and column A, while the done-and-overdue rules sit on Tasks and read Tasks's own columns. Put the overdue rule on the Week tab and it silently does nothing.

The mixed references are doing the work. B$3 locks the row so every cell in a column compares against its own header date. $A4 locks the column so every cell in a row compares against its own time. Google's own examples for custom formulas use the same style.

The current-slot rule uses NOW minus TODAY, which is the fraction of the day that's passed, and compares it to the half-hour in column A. It only moves if the sheet recalculates. Google's calculation settings page, under File then Settings then Calculation, lets you set how often volatile functions like NOW update. Pick the every-minute option if you want the highlight to walk down the column while you work, and leave it if you don't, since Google notes volatile functions can cost performance.

Archiving A Week Without It Moving

At the end of the week, right-click the Week tab and duplicate it, then rename the copy with the date. Then do one more thing or the archive is useless.

B1 still contains TODAY. Google's help for TODAY says it "will always represent the current date the last time the spreadsheet was recalculated, rather than remaining at the date when it was first entered." So the duplicated tab will quietly shift to the current week the next time you open the file, and last week's plan will appear under this week's dates. Select B1 on the copy, copy it, and paste values only, which pins the Monday. Do the same for K3 to K7 if you want the totals frozen too.

I'd also protect the formula cells on the live tab. Google's protect-range help is honest that this isn't security, people can still copy and export, but it stops a stray keystroke in A4 wiping the time column.

Capacity isn't a concern. Google caps a spreadsheet at 10 million cells. Even if every weekly tab used a generous 30,000 cells, a year of them is 52 times 30,000, or 1,560,000, about a sixth of the cap. You'll get bored of the archive long before the sheet does.

Where The Sheet Stops

A spreadsheet planner does three things badly, and I'd rather say so than pretend it replaces everything.

It doesn't notify you. Nothing in this template will buzz your phone at 9:00. If you need that, the routines belong in Google Calendar as recurring events, and the Google Calendar for time management setup covers how to do that on a free account, including the catch on recurring tasks. The sheet is better for planning the week and worse for being reminded of it.

It doesn't measure. The Minutes column is what you estimated, not what happened. If you want to know where the time went, that's a tracker, and the apps for time management comparison prices the free ones.

And it isn't a habit tracker, though the same techniques build one. The habit tracker in Google Sheets piece does the streak-counting version with the same checkbox-and-COUNTIF approach.

What it replaces is the paid daily planner apps, for one person. The day to day planner app comparison found the free tiers of Structured and Ellie take away calendar import and recurring tasks, which are exactly the two things this sheet does for nothing. Where those apps win is the phone. Editing a grid in the Sheets mobile app is possible and not pleasant, so I'd plan on a laptop and read on the phone.

Questions People Ask

How do you use Google Sheets to make a weekly schedule? Build the Week tab above. If it's a schedule for other people, add a column per person instead of per day, or duplicate the tab per person, and print it. Google's print help says landscape is under File then Print under Orientation, and you can repeat frozen rows or columns on every page from Headers and footers, which keeps the day headers and the time column on every sheet of paper.

How do you use Google Sheets to make a planner? Add the Tasks tab. The Week tab is a schedule; the Tasks tab with its per-day filter is what makes it a planner.

Is there a free template for a weekly work schedule? This one. For shift work, change the dropdown on the Tasks tab from weekdays to names and the row 30 filter from TEXT(B$3,"ddd") to the name in the header, and the same formulas produce a rota.

Does Google Sheets have a schedule template? Google's help says the template gallery is at the top right of the Sheets home screen. I couldn't check what's in it without signing in, so I won't list its contents. The number one result for this search isn't from the gallery, it's Smartsheet's shared sheet, and if you use it, File then Make a copy first and change the interval from ten minutes to thirty.

What are some good free Google Sheets planner templates? The honest answer is that the download pages are mostly the same grid with a logo. Retype this one and you'll understand it, which is worth more than a prettier one you can't change.

Does Google have a work scheduling tool? The nearest thing in the consumer apps is the appointment schedule in Google Calendar, which a free account gets one of. For a team rota, it's this sheet. Google's help pages I loaded don't describe a shift scheduler in the free products, and I'm not going to claim one exists.

What I'd Do

Type the two tabs in tonight, from the code block, and don't download anything. Put next week's fixed commitments in the grid first, then the tasks, then look at K6 and see whether the minutes left fit in the empty cells. That comparison is the whole point of putting them on one page.

Run it for two weeks. If what you miss is the notification, move the routines to the calendar and keep the sheet for the Tasks tab. If what you miss is the phone, that's when a paid planner earns its money, and not before.

And when you archive the first week, paste values on B1. That's the mistake I'd expect to make myself.