With your sample data in A1:A12

This formula returns TRUE for weekdays, FALSE for weekends:
B1: =WEEKDAY(TEXT(A1,"0000-00-00"),2)<6

Alternatively, this formula calcs A1 as a date:
B1: =--TEXT(A1,"0000-00-00")
Then you can format it to display as a date or weekday.

Either way, copy the formula down as far as you need.

Is that something you can work with?
or do you need something else?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)
(XL2003, Win XP)

"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