EditReplace will work but the only problem would be *if* you have dates in
February related to leap years.

For example, if you have:

2/28/2008
2/29/2008

Since 2009 is not a leap year then 2/29/2009 is an obvious error and it will
be converted to a TEXT entry.


--
Biff
Microsoft Excel MVP


"Jman" wrote in message
...
I need a easy way to update at the end of year to current year
ex

In row A1:A300
I have static dates . for the whole year. 1/01/08 to 12/31.08

At the end of the year i want to have a easy way to Update them to 2009.
Can i just due cntrl-h
replace 2008 to 2009 or will it throw off the days and become inacurate.
Is there an easier way?