date range conversion
 

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

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

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

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

--

Dave Peterson

Just another way:

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

Format the formula cell as date.

HTH
Jason
Atlanta, GA

-----Original Message-----
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
.

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