Adding months to dates

[Corey]

Is there a way to add months to dates. For example, I want
to have a formula to add 48 months to 08/24/00, so the
formula will present 08/24/04. If I multiply 48 * 30 + the
date, I get 08/03/04. If I divide 48 by 12 times 365, I
get 08/23/04. I would presume there's an easy formula for
this. Help.

Thank in advance.

Corey

 

[Arvi Laanemets]

Hi

With date in A1:
=MIN(DATE(YEAR(A1),MONTH(A1)+48,DAY(A1));DATE(YEAR(A1),MONTH(A1)+1+48,0))


Arvi Laanemets

 

[Corey]

Nevermind...I got it. Thanks anyways!

Corey

 

[IC]

A2 is date. B2 is number of months to add

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

Ian