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 be able to change the year of the date, without changing the day and 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,
Julie

[Don]

Find and replace 2005 with 2006

Don

"zapszipszops" <[email protected]>
wrote in message
news:[email protected]...
>
> 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 be
> able to change the year of the date, without changing the day and
> 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,
> Julie
>
>
> --
> zapszipszops
> ------------------------------------------------------------------------
> zapszipszops's Profile:
> http://www.excelforum.com/member.php...o&userid=33217
> View this thread: http://www.excelforum.com/showthread...hreadid=532852
>

[zapszipszops]

Thanks Don, works great!