software

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: www.excelforum.com/member.php...oamp;userid=33217
View this thread: www.excelforum.com/showthread...hreadid=532852Find and replace 2005 with 2006

Don

quot;zapszipszopsquot; gt;
wrote in message
news:zapszipszops.268ely_1144980001.4058@excelforu m-nospam.com...
gt;
gt; Hi Everyone,
gt;
gt; Is there a way I can easily change the year in a list of randon dates??
gt;
gt;
gt; I have a table in excel, with date in the first column. I need to be
gt; able to change the year of the date, without changing the day and
gt; month.
gt; eg.
gt; 01/12/2005 would need to be changed to 01/12/2006
gt; 04/03/2005 would need to be changed to 04/03/2006
gt; 02/09/2005 would need to be changed to 02/09/2006
gt;
gt; Thanks,
gt; Julie
gt;
gt;
gt; --
gt; zapszipszops
gt; ------------------------------------------------------------------------
gt; zapszipszops's Profile:
gt; www.excelforum.com/member.php...oamp;userid=33217
gt; View this thread: www.excelforum.com/showthread...hreadid=532852
gt;

Thanks Don, works great!--
zapszipszops
------------------------------------------------------------------------
zapszipszops's Profile: www.excelforum.com/member.php...oamp;userid=33217
View this thread: www.excelforum.com/showthread...hreadid=532852