Dates in Excel are simply serial numbers. In the standard date system for Excel, January 1, 1900 is the number 1. January 1, 2017 is 42736, January 1, 2018 is 43101, and January 1, 2050 is the serial number 54,789.
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:
=A1+30// 30 days in the future=A1+90// 90 days in the future
Dates in Excel are just serial numbers that begin on January 1, 1900. If you enter 1/1/1900 in Excel, and format the result with the "General" number format , you'll see the number 1. This means that you can easily calculate the days between two...
The AND function takes multiple arguments and returns TRUE only when all arguments return TRUE. The TODAY function returns the current date. Dates in Excel are simply large serial numbers, so you can create a new relative date by adding or...
In this lesson we look at how to generate an expiration date in the future, how to calculate "days remaining," and how to highlight dates that are "expired" or "expiring soon" with conditional formatting.
Excel Formula Training
Formulas are the key to getting things done in Excel. In this accelerated training, you'll learn how to use formulas to manipulate text, work with dates and times, lookup values with VLOOKUP and INDEX & MATCH, count and sum with criteria, dynamically rank values, and create dynamic ranges. You'll also learn how to troubleshoot, trace errors, and fix problems. Instant access. See details here.