Date & Time
Days Until a Date
Calculate how many days remain until a specific future date. Perfect for countdowns, project deadlines, or event planning.
Excel Formula
=A2-TODAY()Step-by-Step Explanation
1
A2 is the target future date
2
TODAY() returns today's date
3
Subtracting gives the number of days between
4
Result is positive for future dates, negative for past dates
5
Format the cell as Number (not Date) to see the count
Example
| Target Date (A) | Days Until (B) |
|---|---|
| 12/31/2026 | 288 |
| 7/4/2026 | 108 |
| 1/1/2027 | 289 |
Result: Formula in B2: =A2-TODAY() → 288
Common Variations
Weeks until
=INT((A2-TODAY())/7)Whole weeks remaining
Months until
=DATEDIF(TODAY(),A2,"M")Whole months remaining
Countdown text
=A2-TODAY()&" days left"With label text
Need a Custom Version?
Use our AI generator to create a formula tailored to your specific data and requirements.
Try It with AI →