The standard way is:

=DATE(YEAR(A1),MONTH(A1)+9,DAY(A1))

to add 9 months. For 15 years try:

=DATE(YEAR(A1)+15,MONTH(A1),DAY(A1))

HTH
Jason
Atlanta, GA


"Joan" wrote:

I want to be able to add months or years to a date.

For example 25/4/05 + 9 months
25/4/05 + 15 years.

I am using Excel 2000.