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

Ted · Jul 15th 2003

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

**royUK** · Jul 15th 2003

Check out the function DAYS360(). This function calculates on the basis of 360 days in the year, or 12 x 30day months. Not exact, but it might help

Brandtrock · Jul 15th 2003

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

HTH
:usaflag:

rem1224 · Jul 15th 2003

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

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

.......Ralph

Ted · Jul 16th 2003

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

Thanks all.

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

Participate now!

Share