how do i add 1 year to a date formatted cell?

[Guest]

I would like to increase the year in a MM/DD/YYYY formated cell by 1, 2,5 and
10 and place the new dates in other cells. Adding 365 doesn't work because
of leap years. Any suggestions?

 

[Peo Sjoblom]

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

--
Regards,

Peo Sjoblom

(No private emails please)

 

[William]

Hi rogerm

This formula will add one year to the date in cell A1. Replace the "+1" in
the formula with the number of years you want to add.

=DATE(YEAR(A1)+1,MONTH(A1),DAY(A1))
--


XL2003
Regards

William
(e-mail address removed)

 

[Guest]

Let's say the start date is in cell A1. In another cell enter:

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

This will give the date 1 year later. You can change the +1 to +5 to make
it 5 years, etc.

Have a good day

 

[Guest]

Thanks for the help! It works just like I need it to.

 

[Dana DeLouis]

Just want to point out a difference. If A1 has the date 2/29/2004, then
=DATE(YEAR(A1)+1,MONTH(A1),DAY(A1))
returns 3/1/2005
and
=EDATE (A1,12)
returns
2/28/2005

HTH