changing the year of a date

[zapszipszops]

Hi Everyone,

Is there a way I can easily change the year in a list of randon dates?


I have a table in excel, with date in the first column. I need to b
able to change the year of the date, without changing the day an
month.
eg.
01/12/2005 would need to be changed to 01/12/2006
04/03/2005 would need to be changed to 04/03/2006
02/09/2005 would need to be changed to 02/09/2006

Thanks,
Juli

 

[Don]

Find and replace 2005 with 2006

Don

"zapszipszops" <[email protected]>
wrote in message
news:[email protected]...

 

[zapszipszops]

Thanks Don, works great