Date Conversion

  • Thread starter Thread starter JD Silva
  • Start date Start date
J

JD Silva

Hello Ladies & Gentlemen,

I use comma delimited files which I have parsed the data from.
The problem is the date format is not your normal format...
For instance Column A has dates in this format ---> 20031027

or ---> yyyymmdd (Notice there are no separators)

Is there a way to have Excel convert these dates automatically for me
to a mm/dd/yyyy format? (With Separators)

Any help would be very appreciated...
Thanks!

J.D.
 
One way:

Select column A. Choose Data/Text to Columns. Click Next, Next.
Select YMD from the Date dropdown. Click Finish.
 
Hi JD,

This should work for you:

=CONCATENATE(MID(A1,5,2),"/",RIGHT(A1,2),"/",LEFT(A1,4))

but it depends on what happens when you have days and months that are less
than 10...for example do you treat the 1st of January as 20030101 or
200311??

HTH,
Katherine
 
J.E. & Katherine...

Thanks Much!
Both Suggestions Work Just Fine...
I was trying to Find the days between certain dates...
By obviously subtracting the furthest from the most recent...
Voila! Bravo!

As you can see, this was going to be a difficult task based off the
original format...

You can take all my programs from my PC...
Just give me Excel and some numbers to crunch and I'm in analytical
heaven!

Your help is really appreciated!

JD
 
Back
Top