Excel Formula calculate days remaining from today
Sometimes, you may want to know how many days remaining until expiration from today of each food product. In Excel, there is a formula that can help you to quickly get the remaining days.
|MAX(0, exp_date - TODAY())|
|Exp_date: the date that you count days until.|
This formula returns a positive numeric value or zero.
If the expiry date is earlier than today, the formula returns zero, or it returns a positive whole number.
How this formula work
Here in cells B3:B5 list expiration dates, to calculate the days remaining today, please use the formula:
Press Enter key to get the result.
Drag autofill handle to fill cells with this formula.
TODAY function: Get the date of today.
MAX function: Get the maximum value from given range or array.
If you want to calculate the days remaining from a specific date, you can change the general formula to
MAX(0, date- exp_date)
Supposing there is a table, B9:B11 contains expiration dates, C9:C11 are the specific dates you want to count remaining days until. Please use below formula:
Press Enter key to get the result, then drag auto fill handle to the cells you need.
- Calculate days remaining in month
In this tutorial, it provides a formula to quickly calculate the days remaining in month in Excel.
- Assign Points Based On Late Time
This tutorial provides a clear guide on how to use the IF function to assign points on late time in excel.
- Calculate Days Remaining Between Two Dates
Here, this tutorial provides a formula to quickly calculate the left days between two dates.
- Calculate Network Time With Break In A Timesheet
It provides the formula which uses the MOD function to calculate the network time with breaks in Excel.
- Excel IF Function
Test for specified conditions, then returns the corresponding values
- Excel VALUE Function
Convert text to number.
- Excel MONTH Function
The MONTH is used to get the month as integer number (1 to 12) from date.
- Excel DAY Function
DAY function gets the day as a number (1 to 31) from a date
- Excel YEAR Function
The YEAR function returns the year based on the given date in a 4-digit serial number format.