Thread: Count daynames in a defined week

I use the function below to count all days equal to monday in a range of dates, but I want to extend this function to count only mondays with weeknumber 11 as an example. I am aware of the WEEKNUM-function, but it will not work together with SUMPRODUCT because one can not use WEEKNUM on arrays.


Code:
=SUMPRODUCT(--(WEEKDAY(range)=2))

This is a link to my question about counting daynames.

http://www.excelforum.com/excel-gene...-equal-to.html

Try, perhaps:

Code:

=SUMPRODUCT(--(WEEKDAY(range)=2),--(1+INT((range-DATE(YEAR(range+4-WEEKDAY(range+6)),1,5)+WEEKDAY(DATE(YEAR(range+4-WEEKDAY(range+6)),1,3)))/7)=11))