I have been given an Excel file with that contains the installation date for
10,000 items. I need to determine the number of days/years these items have
been in-service. I know the appropriate formula to determine the number of
days between two dates; my problem is the installation date is formatted as
yyyymmdd. So, for example, today appears as 20070521. How can I convert
this is appear as 5/21/07, or some legitimate date format. Thanks in advance
for your help.

Try:
=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))
--
Gary''s Student - gsnu200723

Thanks gsnu. That worked.

"Gary''s Student" wrote:

Try:
=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))
--
Gary''s Student - gsnu200723

I've been meaning to ask you....

gsnu200723

What does that mean?

I think I can figure out what gs means.

Biff

"Gary''s Student" wrote in message
...
Try:
=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))
--
Gary''s Student - gsnu200723

Hi Biff:

The gsnu is just a serial number I append to my username. I change it about
once a week. It assists me in locating old posts to which I may want to
refer. I use gsnuxx for VBA I may want to re-use.
--
Gary''s Student - gsnu200723

That's a good idea!

Biff

"Gary''s Student" wrote in message
...
Hi Biff:

The gsnu is just a serial number I append to my username. I change it
about
once a week. It assists me in locating old posts to which I may want to
refer. I use gsnuxx for VBA I may want to re-use.
--
Gary''s Student - gsnu200723

One more method without the formulas to deal with.

DataText to ColumnsNextNextColumn data formatDate YMD and Finish.


Gord Dibben MS Excel MVP

On Tue, 22 May 2007 19:01:02 -0700, JWNJ wrote:

I have been given an Excel file with that contains the installation date for
10,000 items. I need to determine the number of days/years these items have
been in-service. I know the appropriate formula to determine the number of
days between two dates; my problem is the installation date is formatted as
yyyymmdd. So, for example, today appears as 20070521. How can I convert
this is appear as 5/21/07, or some legitimate date format. Thanks in advance
for your help.

JWNJ wrote...
....
. . . my problem is the installation date is formatted as
yyyymmdd. So, for example, today appears as 20070521. How can I
convert this is appear as 5/21/07, . . .
....

Another formula alternative

=--REPLACE(REPLACE(x,7,0,"-"),5,0,"-")