Date Formulas in Excel

[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

 

[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.