As a result, you can use simple addition and subtraction to calculate dates. In this case, we have a date in the future, so need to subtract the current date to get “days remaining”. The TODAY function returns the current date automatically, so we only need to subtract the result of TODAY() from the date values in column B. Note: if a date has passed, the result will be negative.

Creating an expiration date

To create an expiration date, given a date, you can simply add the number of days until expiration. With a date in A1:

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.