How to have one year value added to another cell

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

AA Arens - 01 Dec 2006 14:24 GMT

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

Reply to this Message

Bob Umlas - 01 Dec 2006 15:29 GMT

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

> I have a cell where I date foramtted fill in the date.
> How to have on another cell the date + one year automatically filled?
[quoted text clipped - 8 lines]
> Bart
> Excel 2003

Reply to this Message

AA Arens - 02 Dec 2006 07:20 GMT

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

> =DATE(YEAR(A1)+1,MONTH(A1),DAY(A1))
> Bob Umlas
[quoted text clipped - 14 lines]
> > Bart
> > Excel 2003

Reply to this Message

Roger Govier - 02 Dec 2006 10:00 GMT

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

Signature

Regards

Roger Govier

> If in a similar way I fill in
>
[quoted text clipped - 32 lines]
>> > Bart
>> > Excel 2003

Reply to this Message

Rate this thread: