A live countdown to a due date is one of the most useful columns in any tracker. It is just subtraction from TODAY() — with a little IF polish for overdue items.
Positive means days left; negative means days overdue.
The example
A list of tasks with due dates. We want days remaining, recalculated every day.
| A | B | |
|---|---|---|
| 1 | Task | Days left |
| 2 | Submit report | 5 |
| 3 | Renew permit | -2 (overdue) |
The formula
The core is a subtraction; TODAY() keeps it current automatically:
How it works
Making it readable:
- Subtract today's date from the deadline. Excel stores dates as numbers, so the result is a count of days.
- A positive number is days remaining; a negative number means the deadline has passed.
- TODAY() recalculates each day the workbook opens, so the countdown is always current.
- Wrap it in IF to label overdue items:
=IF(B2<TODAY(),"Overdue",B2-TODAY()&" days").
Format the cell as a number, not a date, or 5 days will display as January 5, 1900.
Try it: interactive demo
Enter how many days from now the deadline is; see the countdown message.
Variations
Working days until deadline
Count only business days with NETWORKDAYS.
Months and days remaining
DATEDIF breaks a long countdown into months and days.
Pitfalls & errors
If the result shows a date instead of a number, set the cell format to General or Number.
Pair this with conditional formatting to turn rows red when days left drops below zero.
Practice workbook
Frequently asked questions
Why does my countdown show a date?
How do I count only working days?
Will it update on its own?
Stop fighting formulas. Learn them in a day.
This recipe is one of hundreds of real-world formulas we teach. Our Excel Formulas & Functions class covers lookups, logic, text, and dynamic arrays hands-on — live in Dallas–Fort Worth, Houston, Austin, Oklahoma City, Denver, or online.
See the Formulas & Functions Class