MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Date problem


Posted by Douglas Arntt on November 01, 2001 7:56 AM

I am attempting to get Excel to add a number of months to a date already present in a specific cell. I want a formula that can be repeated for all dated cells that follow. Eg: I have a date in C2 (1984/12/23) and I want 54 months added to it to give me the date 4 1/2 years after 1984/12/23 to be in D2. Then I want the same formula to give me an answer in C4 for the next date in D4? Any ideas? I tried using EDATE, but you have to fill in the date, I couldn't get it to accept a "cell" number that has a date in it!?


Posted by Todd on November 01, 2001 8:53 AM

Use the date function as follows:
=date(year(c2),month(c2)+54,day(c2))

Posted by Mark W. on November 01, 2001 9:38 AM

=EDATE(C2,54) works fine for me! (nt)