Date Formulas in Excel

C

Cathy

Hi, Just a questions is it possible to set a formula to
add dates

Example: October 10, 2004 (I need to add one year, minus
one day)

Example: October 10, 2004 (I need to add 15 months, minus
one day)

Any help would be great

Thanks
Cathy
 
H

HCJ

Try this, for example...
for a date in A1, use this in A2:
=DATE(YEAR(A1),MONTH(A1)+15,DAY(A1)-1)

to add 15 months less a day to the date in A1.

Hope this helps.
 
Top