The TODAY guide
=B2-TODAY() counts the days from today to the date in B2. It is 0 on the day itself, negative once the date has passed, and it updates every time the file is opened.
The syntax
=TODAY()
No arguments, but the brackets are required. Without them Excel reads TODAY as a name it doesn't know and shows #NAME?.
Days left
Excel stores a date as a number of days, so subtracting two dates gives the days between them. Deadline minus today is the days left: =B2-TODAY(). Today minus the deadline counts the other way, so every deadline still to come shows as negative.
Due today gives 0. A deadline that passed three days ago gives -3, which is the honest answer. To show 0 instead, wrap it: =MAX(0, B2-TODAY()). To label it, =IF(B2<TODAY(), "Overdue", B2-TODAY()).
If the answer looks like a date
Excel sometimes gives a formula with a date in it a date format, so 11 days shows as 1/11/1900. The value is right; set the cell's format to General or Number.
TODAY changes every day
That's the point of it, and also its catch. A report that should stay as it was on a given date needs that date in a cell instead, like the as-of date in the aging report. To type today's date as a fixed value, press Ctrl+;.
TODAY or NOW?
NOW() includes the time of day. At 9:30 am, a deadline minus NOW() is 3.6 days rather than 4. For whole days, use TODAY.
Common mistakes
- Typing today's date into the formula. It's right today and wrong tomorrow.
- The dates the wrong way round. Deadline minus today, not today minus deadline.
- DATEDIF for days left. It returns #NUM! for every deadline that has passed, because it needs the earlier date first.
Days between two fixed dates: days late.
FAQ
- How do I calculate days remaining in Excel?
- Subtract today's date from the deadline: =B2-TODAY(). The result is 0 on the day and negative after it.
- Why does my days-left formula show a date?
- The cell has a date format. Set it to General or Number and the number of days shows.
- Does TODAY() update automatically?
- Yes. It recalculates whenever the workbook recalculates or is opened, so the result changes every day. Press Ctrl+; to enter today's date as a fixed value instead.
- What is the difference between TODAY and NOW in Excel?
- TODAY returns the date only. NOW returns the date and the current time, so day counts with NOW have a fraction.



































































