For the date:

A1 = 20090707

B1 =

=--TEXT(A1,"000\/00\/00")

Format as Date

For the weekday:

=TEXT(B1,"ddd") - short format, returns Mon
=TEXT(B1,"dddd") - long format, returns Monday

Or, to convert A1 directly to the weekday:

=TEXT(--TEXT(A1,"000\/00\/00"),"ddd")
=TEXT(--TEXT(A1,"000\/00\/00"),"dddd")


--
Biff
Microsoft Excel MVP


"Brandy" wrote in message
...
Hello,

I export data dumps from a file and the date always shows as 20090707
rather
than a proper date. Is there a formula that will help me convert this
into a
proper date file?

I will then want to change that date into just a day of the week. Is that
possible?

Any help would be greatly appreciated.

Warm regards,

Brandy