Countdown in Excel: how many days until a date

Days until a date

Dates are day counts, so the difference between two dates is the number of days between them. E1 holds today's date (November 2, 2026). The $ signs keep the reference fixed when you fill the formula down the list.

The same with DAYS

DAYS(end, start) does the same subtraction and reads more clearly to someone else. Note the order: the later date goes first.

Make it a live countdown with TODAY()

To have the sheet update by itself, use TODAY() instead of a fixed cell. It returns the current date every time the workbook recalculates, which includes every time you open it.

Keep the cell format General. Excel sometimes formats the result of a date subtraction as a date, which turns 25 into January 25, 1900.

1. In C2 type =B2-TODAY() and press Enter.
2. If it shows a date, choose Home > Number Format > General.
3. Double-click the fill handle to copy it down the list.
4. Optional: put =TODAY() in one cell (E1) and point every row at $E$1, so you can test the sheet with any date.

Working days until a deadline

Project deadlines usually care about working days. NETWORKDAYS counts Monday to Friday between two dates, including both ends. Add a holiday range as the third argument to skip public holidays as well.

Weeks and days, or a "days to go" label

Large numbers of days are hard to picture. INT gives the whole weeks and MOD the days left over. For a dashboard tile, join the number to text instead: =B2-$E$1&" days to go".

Dates that have already passed

Once the date is behind you, the subtraction goes negative. Show a clear label instead. The trade show here was on October 20.

To count months instead of days, DATEDIF works: =DATEDIF($E$1,B5,"m") returns 4 full months to the launch. DATEDIF returns #NUM! if the start date is after the end date, so check the order.