In the example shown, the formula is solved like this:
Days remaining from today
If you need to calculate days remaining from today, use the TODAY function like so: The TODAY function will always return the current date. Note that after the end_date has passed, you’ll start to see negative results, because the value returned by TODAY will be greater than the end date. You can use this version of the formula to count down days to an important event or milestone, count down days until a membership expires, etc.
Remaining workdays
To count remaining workdays, see the NETWORKDAYS function and the example here.
Dave Bruns
Hi - I’m Dave Bruns, and I run Exceljet with my wife, Lisa. Our goal is to help you work faster in Excel. We create short videos, and clear examples of formulas, functions, pivot tables, conditional formatting, and charts.
