how to solve this by countif
 

anybody please,

i got another head butt from by boss,

something like this

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

thank you
driller

how to solve this by countif
 

=SUMPRODUCT(--(holidays<=D4),--(holidays<1))
see

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

http://mcgimpsey.com/excel/formulae/doubleneg.html

happy new year
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"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

how to solve this by countif
 

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

how to solve this by countif
 

Thanks Sir Bernard

happy holidays
more full power
driller


"Bernard Liengme" wrote:

=SUMPRODUCT(--(holidays<=D4),--(holidays<1))
see

http://www.xldynamic.com/source/xld.SUMPRODUCT.html

http://mcgimpsey.com/excel/formulae/doubleneg.html

happy new year
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"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

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