how to solve this by countif

D

dribler2

anybody please,

i got another head butt from by boss,

something like this

=countif(holidays,"<="D4) &if weekday(holidays)<>1

thank you
driller
 
T

T. Valko

What does the 1 represent? Sunday?

=SUMPRODUCT(--(holidays<=D4),--(WEEKDAY(holidays)<>1))

Or:

=SUMPRODUCT(--(holidays<=D4),--(TEXT(holidays,"ddd")<>"Sun"))

Biff
 
Top