Step by step
- Type your target date into cell A2.
- In cell B2, enter =A2-TODAY() and press Enter.
- Open Format > Number > Number if Sheets displays a date instead of a count.
- For a live clock you can put on a second screen, enter a name and date in the tool on this page and press Full screen.
At a glance
| Option | When to use it | What it shows |
|---|---|---|
| =A2-TODAY() | Shared team tracker with many dates | Whole days remaining |
| =NETWORKDAYS(TODAY(),A2) | Workweek project deadlines | Working days only |
| Browser countdown tool | Live display for one event | Days, hours, minutes, seconds, weeks, working days |
Where to find it on your device
- Google Sheets format: Format > Number > Number
Related questions
Does TODAY() update automatically in Google Sheets?
Yes, Google Sheets recalculates TODAY() when you open the sheet or when edits occur, though it does not tick every second.
How do I count only weekdays in Google Sheets?
Use =NETWORKDAYS(TODAY(), A2) to count Monday through Friday between today and your target date.
Can I keep a Google Sheets countdown on a second monitor?
A sheet works for tables, but the tool on this page has a Full screen button made for a second screen.
More questions: countdown to a date
- How to Countdown to a Date on iPhone
- How to Set a Countdown to a Date on Android
- How Do I Put a Countdown Clock on My Desktop?
- How to Countdown to a Date in Excel
- How to Countdown to a Date Without Weekends
- How to Set a Countdown to a Specific Date and Time
- How to Set Up a Countdown for a Birthday or Wedding
- How to Add a Date Countdown in Canva vs. a Live Timer
- How to put a countdown on Instagram or WhatsApp
Open the full countdown to a date →
Updated November 14, 2026.