Add months to date

Add months to date

Generic formula 

=EDATE(date,months)

Related formulas 

Add years to date

Add days to date

Explanation

To add a given number of years to a date, you can use the EDATE function.

In the example shown, the formula in D5 is:

=EDATE(B5,C5)

How this formula works

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

Add months to date

Generic formula 

=EDATE(date,months)

Related formulas 

Add years to date

Add days to date

Explanation

To add a given number of years to a date, you can use the EDATE function.

In the example shown, the formula in D5 is:

=EDATE(B5,C5)

How this formula works

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