Return days remaining as of today
This tutorial shows how to calculate the remaining days as of today using an Excel formula, with the MAX function
|
GENERIC FORMULA
=MAX(0,date-TODAY())
ARGUMENTS EXPLANATION This tutorial shows how to calculate the remaining number of days as of today using an Excel formula, with the MAX function.
Excel represents dates as serial numbers therefore by simply taking today's date, using the TODAY function, and subtracting it from the date that you want to calculate the remaining days the formula will return the remaining number of days.
However, in a scenario where the date is before today's date the formula returns a negative value, therefore, we are using the MAX function to isolate negative values and return a value of zero (0). |
RELATED TOPICS
| Related Topic | Description | Related Topic and Description |
|---|---|---|
| Return date overlap in days | How to return the number of days that overlap between two date ranges |
RELATED FUNCTIONS
| Related Functions | Description | Related Functions and Description |
|---|---|---|
| MAX Function | The Excel MAX function returns the largest value from a specified range of numeric values | |
| TODAY Function | The Excel TODAY function returns the current date |