How to have one year value added to another cell

A

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
 
A

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
 
R

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))
 
Top