date range conversion

[Guest]

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

 

[Dave Peterson]

=date(2005,month(a1),day(a1))

will work for almost every date--except for Feb 29, 2004.

 

[Jason Morin]

Just another way:

=--(TEXT(A1,"m/d/")&"05")

Format the formula cell as date.

HTH
Jason
Atlanta, GA

 

[Guest]

Thanks Guys, it worked perfectly...