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)
