Excel Countdown Timer Formula: Days, Hours, and Minutes Until a Date

Q: How do I create a countdown timer in Excel?

Use =A2-TODAY() for days remaining, or =INT(A2-NOW())&" days, "&HOUR(A2-NOW())&" hrs" for a detailed countdown.

Q: Does Excel update the countdown automatically?

Only when the workbook recalculates. TODAY() updates on open; use F9 to force update for NOW().

Q: How do I count only working days in the countdown?

=NETWORKDAYS(TODAY(), A2)-1 counts remaining business days excluding weekends.

While Excel isn't a real-time clock, you can build powerful countdown formulas that show the time remaining until any future date — perfect for project deadlines, event planning, and expiration tracking.

Days Remaining Until a Date

=A2-TODAY()

Where A2 is your target date. Format the result as a Number (not Date) to see the number of days. Negative values mean the date has passed.

Days, Hours, and Minutes Remaining (Text Display)

=INT(A2-NOW())&" days, "&HOUR(A2-NOW())&" hrs, "&MINUTE(A2-NOW())&" min"

Example output: "14 days, 3 hrs, 27 min"

Note: This uses NOW() which updates whenever the sheet recalculates (on open or F9).

Countdown in Business Days

=NETWORKDAYS(TODAY(),A2)-1

Subtract 1 because NETWORKDAYS includes today.

Show "Overdue" If the Date Has Passed

=IF(A2



Countdown Clock (Requires Manual Refresh)
Excel doesn't auto-refresh in real time. Press F9 or Ctrl+Alt+F9 to force recalculation and update NOW()-based formulas.

Conditional Formatting: Color Code by Urgency

  Red: =A2-TODAY()<=3 (3 days or less)
  Yellow: =AND(A2-TODAY()>3, A2-TODAY()<=7)
  Green: =A2-TODAY()>7


FAQ
How do I create a countdown timer in Excel?
Use =A2-TODAY() for days remaining, or =INT(A2-NOW())&" days, "&HOUR(A2-NOW())&" hrs" for a detailed countdown.
Does Excel update the countdown automatically?
Only when the workbook recalculates. TODAY() updates on open; use F9 to force update for NOW().
How do I count only working days in the countdown?
=NETWORKDAYS(TODAY(), A2)-1 counts remaining business days excluding weekends.

Related: Calculate Business Days Between Dates and Excel Age Calculator.