date range conversion

T

tssjhs

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
 
D

Dave Peterson

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

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

Jason Morin

Just another way:

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

Format the formula cell as date.

HTH
Jason
Atlanta, GA
 
Top