Date question? update year.
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?
|