One way with your data in A1:

=TEXT(MID(A1,5,2)&"/"&RIGHT(A1,2)&"/"&LEFT(A1,4),"dddd")

HTH,
Paul

--

"carl" wrote in message
...
My date data comes in like this....

20071202
20071202
20071203
20071203
20071203
20071203
20071203
20071203
20071204
20071204
20071204
20071204


Is there a formula that can identfy weekdays ?

Thank You In Advance