Adding Months to Date Help

Posted by Brett on April 30, 2001 12:26 PM

I'm using Excel 97. I have a column of dates (ie 04/30/2001) and a column of months expressed as a number (ie 30) I want to add the months to the date to arrive at what 30 months from 04/30/2001 is in a mm/dd/yyyy format. I hope this makes sense.

Thanks.

Posted by Kevin James on April 30, 2001 12:43 PM

Given that A2 contains the date you want to "mark up"....

=DATE(YEAR(A2),MONTH(A2)+30,DAY(A2))

Posted by Dave Hawley on April 30, 2001 1:17 PM

Hi Brett

You can also do this with the EDATE function. This is an add-in so first go to Tools>add-ins and tick the "Analysis Toolpak".

Then if your date is in cell A1 and your months is in cell B1, use:

=EDATE(A1,B1)and format as a date.

Dave
OzGrid Business Applications

Posted by Brett on April 30, 2001 1:55 PM

Thanks for the quick help!