Date formula

  • Thread starter Thread starter CB
  • Start date Start date
C

CB

Hi,
I would like to be able to add months to a particular
date. For example, March 5, 2004 is 4/5/04 and I would
like to add 9 months to that date so that Excel takes
care of the different lengths of months into account.

I guess the formula would look something like:

=A4+9months
where A4 contains the starting date.

Thanks for your help!
 
Hi
try as a genral formula
=DATE(YEAR(A4),MONTH(A4)+add_months,MIN(DAY(A4),DAY(DATE(YEAR(A4),MONTH
(A4)+add_months+1,0))))

for adding 9 months use
=DATE(YEAR(A4),MONTH(A4)+9,MIN(DAY(A4),DAY(DATE(YEAR(A4),MONTH(A4)+9+1,
0))))
 
Back
Top