Increase years by one formula

[cwarrenpcm3]

Hello all!

I need help with a formula...

I have a date (1/1/04 but displayed as Jan-04) in cell E4.
I would like to have a formula that looks at E4 and returns the sam
date but increase the year by one 1. Every formula I have trie
doesn't work or increases the month by one. Any help would b
appreciated!
Cind

 

[Patti]

I'm sure there's a better way, but one way is:

=E4+366

 

[David McRitchie]

Hi Patti,

How many years have 366 days ? (about 1 in 4)

instead use:
=date(year(e4)+1,month(e4),Day(e4))

More information on Date and Time
http://www.mvps.org/dmcritchie/excel/datetime.htm
http://www.cpearson.com/excel/excel.htm

 

[Patti]

Like I said, I'm sure there's a better way! Thanks!

-----Original Message-----
Hi Patti,

How many years have 366 days ? (about 1 in 4)

instead use:
=date(year(e4)+1,month(e4),Day(e4))

More information on Date and Time
http://www.mvps.org/dmcritchie/excel/datetime.htm
http://www.cpearson.com/excel/excel.htm


"Patti" <[email protected]> wrote in

message news:[email protected]...