Life in Weeks Tracker in Google Sheets (15-Min Setup)

You can build a life-in-weeks tracker in Google Sheets in 15 minutes. Create a simple weeks grid, add one Start Date cell, calculate the current week from TODAY(), and use conditional formatting to highlight "This Week" and color shipped weeks green.

It's like an accountability coach for your week, except the grid is the mirror.

Why Google Sheets beats Notion for this

If you're a drift-prone founder, you don't need a second brain. You need a weekly finish line.

Google Sheets works better because:

Fast setup. No databases, no properties, no views.
Great grid visualization. Conditional formatting makes "This Week" obvious.
Portable. Duplicate, share, and print without tool lock-in.
Binary tracking works. One checkbox per week is enough.

What you'll have in 15 minutes:

A weeks grid where 1 cell = 1 week
An automatic "This Week" highlight based on today
A single Shipped checkbox per week
Optional: a one-line Ship Note for what you shipped

A week is a unit of execution. Drift kills weeks.

The founder-simple template rules

This tracker only works if it stays blunt.

Non-negotiables:

One cell equals one week
One checkbox equals Shipped or Not Shipped
Optional: one short note (5-10 words max)

What you don't add:

Tags
Project lists
Dashboards
Backlogs
"Someday" lanes

Busy isn't progress. Shipped is progress.

Step-by-step: Build the tracker (15 minutes)

Step 1: Create the grid (Years x Weeks)

Layout (laptop-friendly):

Rows = years
Columns = weeks (1-52)

52 columns fits most screens when zoomed out.

Create a new Google Sheet
In A1, type: Year
In B1, type: 1
In C1, type: 2
Select B1:C1, drag right until week 52

Now create year labels:

A2: enter 0 (or 1 if you prefer "Year 1")
A3: enter 1
Drag down to 80 (for an 80-year grid)

Quick math: 80 years ≈ 4,160 weeks.

Step 2: Add a Start Date cell

Everything keys off one date.

In A83 (empty area under the grid):
- A83: Start Date
- B83: enter your date (example: 1992-06-14)

Choose one:

Life tracker: your date of birth
Business tracker: the day you started building

For founders focused on shipping, the business start date often hits harder.

Step 3: Calculate "current week index"

You need one number: which week are we in since the start date?

A84: Week Index (since start)
B84: paste this formula:

=INT((TODAY()-$B$83)/7)+1

This returns Week 1 for the first 7 days, Week 2 after that, and so on.

Step 4: Create a week index map (helper grid)

Conditional formatting needs each cell to know its week number.

Pick empty area to the right (example: starting at BA2)
BA1: WeekIndexMap
BA2: paste this formula:

=ARRAYFORMULA(($A2:$A81)*52 + (COLUMN($B$1:$BA$1)-COLUMN($B$1)+1))

This computes week indices: 1-52, then 53-104, etc.

Step 5: Add checkboxes

Select grid range B2:BA81
Go to Insert → Checkbox

Now each week cell is TRUE/FALSE.

Step 6: Add conditional formatting

Go to Format → Conditional formatting and add these rules:

Rule 1: Shipped weeks = green

Apply to range: B2:BA81
Format cells if: Custom formula is
Formula: =B2=TRUE
Format: green fill

Rule 2: This Week = bright highlight

Apply to range: B2:BA81
Custom formula: =BA2=$B$84
Format: bright yellow fill

Rule 3: Past weeks (not shipped) = light gray

Apply to range: B2:BA81
Custom formula: =AND(BA2<$B$84, B2<>TRUE)
Format: light gray fill

Step 7: Add "Weekly Ship" notes (optional)

Create a simple log below the grid:

A86: Week Index
B86: Ship Note

Example entries:

214 | Shipped onboarding email + Stripe webhook
215 | Launched landing page, 12 signups

Keeps the grid clean while giving you context.

How to use it (the weekly ritual)

This grid isn't a journal. It's a shipping scoreboard.

Monday (2 minutes): Define what earns a green box

"What is the one outcome I will ship by Friday?"

In FocusNinja, this is your Weekly Intention. Pick one thing. Track wins. Get a weekly verdict.

Midweek (60 seconds): Catch drift

"Is this week still on track to be green?"

This maps to FocusNinja's Midweek Pulse. Start aligned in the morning. Correct drift midweek. Review on Sunday.

Friday (60 seconds): Close the loop

If you shipped, check the box
Write a 5-10 word note
If you didn't ship, leave it blank (no excuses)

Make it business-useful, not existential

A life-in-weeks tracker is often used as a "time is short" poster. For founders, that can turn into guilt.

Use it as a drift radar:

Green streaks show momentum
Blank clusters show avoidance or unclear goals
One green box per week builds real confidence

FocusNinja makes this practical by turning the week into an execution loop:

Morning Anchor: start aligned to your One Thing
Midweek Pulse: correct drift early
Weekly Review: get a verdict (Shipped, Wasted, or Enjoyed)

Log wins. The coach uses wins as evidence.

Optional upgrades (stay simple)

Add a shipped count

In an empty cell:

=COUNTIF(B2:BA81, TRUE)

This shows total shipped weeks.

Add yearly shipped rate

In BB2:

=COUNTIF(B2:BA2, TRUE)/52

Format as percent. Copy down for each year.

Make it printable

File → Print
Set Landscape
Set Scale: Fit to width
Turn on Gridlines

The tool is the mirror. The system is the engine.

A Google Sheets life-in-weeks tracker shows the truth fast. It answers "did I ship this week?" without negotiation.

But a mirror doesn't change behavior. A loop does.

If you want more green weeks, you need FocusNinja's execution system:

Set a North Star so your weeks aim in one direction
Commit to one outcome for the week
Log wins as evidence
Let the AI coach give the weekly verdict so you don't rationalize drift

The tracker shows the pattern. FocusNinja builds the habit.

FAQ

Can I get a template to copy? Duplicate your finished sheet (File → Make a copy) and use it as your template.

Birthday vs business start date? Use birthday for life tracking. Use business start date for shipping focus. The "This Week" highlight updates automatically.

80 years or 90 years? Use 80 years for clean fit. Use 90 if you want more runway. The habit is weekly shipping, not perfect forecasting.

What counts as "shipped"? Completed outcomes that moved the business forward:

Deployed a feature users can access
Launched a landing page collecting emails
Closed a deal after a sales sprint
Published content that went live

In FocusNinja, your logged wins are the evidence.

What if I didn't ship? Leave it blank for a calm scoreboard. The pattern matters more than individual weeks. Choose a tighter Weekly Intention next week.

Build a Life-in-Weeks Tracker in Google Sheets (15-Minute Setup)