With the date in A1 try the below in B1 and format B1 to excel date format

=DATE(LEFT(A1,4),MID(A1,5,2),RIGHT(A1,2))

OR

RightclickFormatCellsCustom
dddd
to display the day alone like Tuesday

OR

If you are looking at Day number of week try the below formula instead

=WEEKDAY(DATE(LEFT(E1,4),MID(E1,5,2),RIGHT(E1,2)))

If this post helps click Yes
---------------
Jacob Skaria


"Brandy" wrote:

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