I would run the data through DataText to ColumnsNextNextColumn Data
FormatDateYMD

Then in an adjacent column enter =WEEKDAY(cellref) and copy down.


Gord Dibben MS Excel MVP

On Mon, 17 Dec 2007 12:11:08 -0800, carl wrote:

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