Thank you all for your responses. I knew there were genius's out there!
Diane

"Dave Peterson" wrote in message
...
With my USA settings and 60501 in A1:
=--TEXT(20000000+A1,"0000\/00\/00")
Gave me May 1st, 2006




LDL wrote:

I am transferring data from an AS400 into Excel. The date field comes
into
Excel like this: 60501. This date is actually 05-01-06. Just like
Excel,
the AS400 suppresses the leading 0 in the date. We cannot get the date
data
to come into Excel any differently. I need to convert this number into a
date but don't know how. I don't know if you can create 1 formula to do
this or create multiple formula's to do it. The concatenate function
allows
me to place a 0 in front of the 6. That gets me all the numbers needed
for
a date, but now I need to swap the numbers around and separate into
mm/dd/yy. My ultimate goal is to calculate the number of workdays
between 2
dates. I have over 2,000 rows of data and was hoping for an automated
way
to do this every month. Are there any genius's out there that can help?
Thanks, Diane

--

Dave Peterson