Increase years by one formula

C

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
 
P

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
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Patti" <[email protected]> wrote in
Click to expand...
message news:[email protected]...
 
Top