maybe

=IF(AND(OR($A7={"mon","Tue","Wed","Thu","Fri"}),$D 7="Defect"),1, 0)

"cashman" wrote:

I am creating a if/then formula that will look at a cell in column A that
contains either one of the following day notations MON, TUE, WED, THU, FRI,
SAT, SUN, or HOL. If the date is between any non holiday weekday it should
be included in a count. The second part of the if/then statement includes
the choice between OK and DEFECT. I am trying to count only the defects that
happen during non holiday dates for entire month. I have written the
following formula for a single day but have had no luck. Can anyone point me
in the right direction?

=IF((($A7=MON, TUE, WED, THU, FRI)=AND($D7=DEFECT)),1,0)