Skip to content
Sobriety Day Counter cover: a sample sheet with days since the first entry, check-ins and steady check-ins and a bar chart, beside the Dashboard and Log tabs

Sobriety Day Counter

Spreadsheet template for Google Sheets and Excel

Make a copy in Google Sheets
Price
Free
Slides
5
Difficulty
Beginner
Updated
November 13, 2026

Every slide (5)

Overview

This day counter is for anyone tracking time since they stopped drinking or using a substance. The Log tab keeps a row per check-in, with how the day went, any trigger and a brief note. The Dashboard shows days since the first entry, the number of check-ins, steady check-ins and tempted or hard days, plus a bar chart of harder check-ins by trigger. The Milestones tab marks each goal as Reached or Not yet.

Enter your start date as the first row, because the day count runs from the earliest date in the log. Write notes you would be glad to read on a hard day, and keep the file somewhere private. A harder check-in is information rather than a verdict, and the triggers chart can show where extra support would help most.

Useful for

  • Counting the days since stopping alcohol
  • Logging triggers to bring to a counselor
  • Marking one-week, one-month and one-year goals

What's included

  • 4 tabs: Dashboard, Log, Milestones, How to use
  • Dashboard: a dashboard with 4 summary figures
  • Log: a table
  • Milestones: a table
  • 1 chart that update as you type
  • Formulas, dropdowns and colour rules already set up
  • Sample rows that show how to fill it in

How to use it

  1. 1

    Click Make a copy in Google Sheets, then confirm on the Google page. The copy is saved to your own Google Drive.

  2. 2

    Start on the Log tab: replace the sample rows with your own.

  3. 3

    Keep the formula columns as they are; they fill in as you type.

  4. 4

    Read the How to use tab for tips. For Excel, download the .xlsx file instead.

What you need

Requirements

  • A Google account, or Microsoft Excel for the download

Works with

  • Google Sheets
  • Microsoft Excel (download the .xlsx)

Questions

Does a day counter help with recovery?

Some people find a visible count motivating, and others find it stressful. Use the counter only if it helps. Support from a doctor, counselor or peer group does the heavy lifting, and this file can only record what you tell it.

What if I have a hard day or a slip?

Record it honestly, choose the check-in type that fits and note the trigger. The day count runs from the earliest date in the log. If you decide to start again, add a new row and talk it through with your support contact.

Can I share the file with my sponsor?

Yes, if you choose to. Share a copy with only the Log and Milestones tabs, or send a printed summary, so notes you want to keep private stay private. Keep the original file on your own device.

  • #habit-tracker
  • #sobriety-tracker
  • #google-sheets
  • #excel
  • #spreadsheet-template
  • #free-template

More habit tracker templates

See all 15

Also in Business operations

All business operations templates
Get this template

Preparing your template…