update month itervals automatically

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
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
 
One possible way

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

Regards,

Peo Sjoblom
 
Back
Top