Thanks Guys, it worked perfectly...

"tssjhs" wrote:

Hello,

I need to convert dates ranging from 1999 through 2004 to 2005 dates. Can
this be done????? thanks.....

Example,

A1 B2
01/05/1999 01/05/2005
03/18/2003 03/18/2005
09/01/2002 09/01/2005