how to solve this by countif
Thank you Sir Biff
Happy holidays
more full power
driller2
"T. Valko" wrote:
What does the 1 represent? Sunday?
=SUMPRODUCT(--(holidays<=D4),--(WEEKDAY(holidays)<1))
Or:
=SUMPRODUCT(--(holidays<=D4),--(TEXT(holidays,"ddd")<"Sun"))
Biff
"dribler2" wrote in message
...
anybody please,
i got another head butt from by boss,
something like this
=countif(holidays,"<="D4) &if weekday(holidays)<1
thank you
driller
|