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!?