Excel Formula: Count Days Until Expiration Date

Supposing there is a list of expiration dates, how can you count the days between today and each expiration date in Excel by formula?

If you want to follow along with this tutorial, please download the example spreadsheet.

Generic formula:

Expiration_date-TODAY()

Syntaxt and Arguments

Expiration_date: the date that expires.

Return Value

The formula returns a numeric value. If the result is a negative value, it means the expiration date is in past.

Error

#VALUE! error appears when:

1) The expiration_date argument is not a valid date in Excel.

2) The expiration_date argument is less than 1/1/1900.

How this formula works

To count the days until expiration dates in cell B3:B5, please use below formula:

=B3-TODAY()

Press Enter key to get the first result, then drag autofill handle down to cell C5.

Explanation

TODAY function: gets today date.

---

Relative Formulas

• Count the days of the month
  This tutorial provides formulas to count the total days of the month based on the given date.
• Check two dates are in the same year month
  To check if two dates in the same year month, you can use the formula in this tutorial.
• Create date range from two dates
  This tutorial provides a formula with TEXT function to create a date range based on two dates in text format in Excel.
• Create weekly date range
  In this tutorial, it provides a formula to quickly get the weekly date range in Excel.

Relative Functions

• Excel WEEKNUM Function
  Returns the week number of the given date in a year
• Excel WORKDAY Function
  Adds workdays to the given start date and returns a workday
• 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 NOW Function
  Get the current time and date