update month itervals automatically

[Odart]

If say something was done in May-04 and it's not due again for another 15
monthes how do I get excel to due the math and then when it get's done in 15
monthes exel will do the math when I put the date in

 

[OZDOC1050]

4/05/2004
15
4/08/2005


you could use EDATE

a1 = start date
a2 = months
a3 = =EDATE(A1,A2)

SEE NOTES ON EDATE BELOW
If this function is not available, and returns the #NAME? error, install
and load the Analysis ToolPak add-in.

R
Pete

 

[Peo Sjoblom]

One possible way

="Due in "&TEXT(DATE(YEAR(A1),MONTH(A1)+15,DAY(A1)),"mm/dd/yyyy")

Regards,

Peo Sjoblom