Adding months to dates

C

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
 
A

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
 
Top