Idenfying WeekDays
 

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

Idenfying WeekDays
 

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

Idenfying WeekDays
 

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

Idenfying WeekDays
 

hi try this

=weekday(date(left(a2,4),month(mid(a2,5,2),day(rig ht(a2,2))

hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo



"carl" escreveu:

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

Idenfying WeekDays
 

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