Posted to microsoft.public.excel.worksheet.functions
|
|
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
|