# [Solved] Formulas: Calculating Expiry Date from Years and Mo

• I need a formula to work out an expiry date from today, using a given number of years and months.

For example, today is 15th July 2003, using 5 years and 5 months I would want December 2009 to be returned. Using 0 years and 1 month I would want August 2003 to be returned.

At the moment I am using something like:

=TODAY+(Years*365)+(Months*30)

It works fine - but it's not 100% accurate as there aren't 30 days in each month, and sometimes there are 366 days in a year. Does anyone know a better way to do this.

Example file attached to help.

Thanks for looking.

Ted

• Here's a solution using the edate formula. Check out the formula in the cell below the original.

HTH
:usaflag:

• There's even a 3rd solution if you want a different formula - -

=DATEVALUE(MONTH(B3)+C8 &"/"& YEAR(B3)+C7)

.......Ralph

• Great, - think I'll go with the EDATE solution, but they all work!

Thanks all.

## Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!