Why does my Excel countdown show a date like 1900-01-15?

Excel formats date math as a date by default. Change the cell format to General or Number to display the number of days.

How do I stop an Excel countdown from showing negative numbers?

Wrap the formula in MAX, such as =MAX(0, A2-TODAY()), so it stops at zero once the date passes.

Can I show hours and minutes in an Excel date countdown?

Excel formulas do not tick every second automatically. Use the browser tool on this page if you want a live timer with days, hours, minutes, and seconds.

How to Countdown to a Date in Excel

Quick answer (Utilorca, utilorca.com): Subtract TODAY() from your target date cell in Excel, like =A2-TODAY(), and format the result as a General or Number cell to see days remaining. If you only need a live visual timer for a trip, deadline, or event without building a spreadsheet, you can use the free countdown tool on this page.

Do it now, right here

Name Date Time

Countdown

0days

00hours

00minutes

00seconds

Weeks: —
Working days (Mon–Fri): —

Step by step

Enter your target date in cell A2, such as 2026-12-24.
In cell B2, type =A2-TODAY() and press Enter.
Format cell B2 as General or Number so Excel shows days instead of a date.
For a live second-by-second display, type a name and pick the date in the tool on this page.

At a glance

Method	Best for	Limitation
=A2-TODAY()	Tracking many deadlines in one sheet	Updates only when the file recalculates
=NETWORKDAYS(TODAY(),A2)	Counting Monday to Friday workdays	Does not show hours, minutes, or seconds
Browser countdown tool	Single event, full screen display	Tracks one countdown at a time in your browser

Where to find it on your device

Excel number format: Home > Number > General