Dates & Time

Excel formula for Days until a future date

Count down the days remaining until a deadline or event.

Copy this formula

=A2-TODAY()

How the formula works

Subtracting today's date from a future date gives the days left, and it updates every day because TODAY() is dynamic. A negative result means the date has passed.

Examples

=IF(A2-TODAY()<0, "Overdue", A2-TODAY()&" days")→12 days

Days left, or "Overdue".

FAQ

How do I count only working days left?

Use =NETWORKDAYS(TODAY(), A2) to exclude weekends.

Related formulas

Days between two dates Calculate age from a birth date

Functions used

TODAY DAYS

Need a formula for your own data?

Describe what you want in plain language and let ExcelGPT write, explain, and verify the formula — free to start, no plugin.

Try ExcelGPT free