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

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?

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

--
Regards,

Peo Sjoblom

(No private emails please)


"rogerm" wrote in message
...
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?

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



"Rogers" wrote in message
...
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?

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
--
Gary's Student


"rogerm" wrote:

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?

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

"rogerm" wrote:

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?

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
--
Dana DeLouis
Win XP & Office 2003


"rogerm" wrote in message
...
Thanks for the help! It works just like I need it to.

"rogerm" wrote:

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?