Add months to date help

Topic

New Reply

I’m using Excel 97. I have a column of dates expressed as 04/30/2001 and a column of number of months expressed as a single number, ie 30. I want to add the number of months to the date to find out what the date will be in 30 months in mm/dd/yyyy format. Hope this makes sense.

Thanks.

Reply | Quote

Replies

The following formula will add the the value in B1 to the month part of a date in A1, so if B1 = 12, then the formula will add 12 months (1 yr) to the date in A1.

=DATE(YEAR(A1),MONTH(A1)+B1,DAY(A1))

You can format the cells containing the formula as required

Andrew

Reply | Quote

Thanks Andrew. FYI – I also found out that EDATE will do the same thing.

Regards,

Brett

Reply | Quote

Brett,

yes EDATE() is fine, but you must have the Analysis Toolpak AddIn installed to use it. Not all users bother to install it.

Andrew

Reply | Quote