Explanation
The EDATE function is fully automatic. Simply supply a valid date and a number of months and EDATE will return a new date. To subtract months from a date, supply a negative value.
Adding years
To move forwards and backwards in years from a certain date, you can multiply by 12 inside EDATE like this:
=EDATE(A1,12*10) // 10 years
=EDATE(A1,12*50) // 50 years
Related formulas
Add years to date
In this example, the goal is to use a formula to add or subtract a given number of years ( n ) to a date. There are two main ways to go about this in Excel. The first method uses the YEAR, MONTH, and DAY functions to take apart the date into separate components: year , month , and day . Then it...
Add days to date
Dates in Excel are just serial numbers. The number 1 represents January 1, 1900, the number 1000 is September 26, 1902, and so on. When you have a valid date in Excel, you and just add days directly. Day values can be positive or negative. For example, with a date in A1, you can add 100 days like...
Related functions
EDATE Function
The Excel EDATE function returns a date on the same day of the month, n months in the past or future. You can use EDATE to calculate expiration dates, maturity dates, and other due dates. Use a positive value for months to get a date in the future, and a negative value for dates in the past.
