Calculation months from date

This formula will give you what you are after

="contract start date + " &(YEAR(D5)-YEAR($E$1))*12+MONTH(D5)-MONTH($E$1) & " month"

Just place it in cell B5 and drag it down. Note you will need to remove the formula in D5 or it will cause a circular reference

For more info on the formula see
http://support.microsoft.com/kb/214134

Michael

You can use DATEDIF to determine the number of months between two dates, perhaps try this version

="contract start date + "&DATEDIF(E$1,D5,"m")&" months"

regards, barry

Hi Michael,

This seems to be working except for one thing.  I put the formula in Column B, but no date in Column D, then it show a weird display in column B.  Can I hide whats in column B until a valid date has been entered in column D

Eddie