Idenfying WeekDays

  • Thread starter Thread starter carl
  • Start date Start date
C

carl

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
 
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)
 
One way with your data in A1:

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

HTH,
Paul
 
hi try this

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

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



"carl" escreveu:
 
I would run the data through Data>Text to Columns>Next>Next>Column Data
Format>Date>YMD

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


Gord Dibben MS Excel MVP
 
Back
Top