How to have one year value added to another cell

[AA Arens]

I have a cell where I date foramtted fill in the date.
How to have on another cell the date + one year automatically filled?

So,

A1 02-04-06

auto:
B1 02-04-07


Bart
Excel 2003

 

[Bob Umlas]

=DATE(YEAR(A1)+1,MONTH(A1),DAY(A1))
Bob Umlas
Excel MVP

 

[AA Arens]

If in a similar way I fill in

12-02-06
and
=DATE(DAY(M8),MONTH(M8),YEAR(M8)+1)

I get:

12-02-06
and
05-29-08 (=1908)

Both cells are formatted as Date.

Bart

 

[Roger Govier]

Hi

No, the DATE() function must have the parameters in the order of Year,
Month, Day

Change your order to the order that Bob gave you in his formula
=DATE(YEAR(M8)+1,MONTH(M8),DAY(M8))