Count daynames in a defined week

[mkvassh]

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

[NBVC]

Try, perhaps:

Please Login or Register  to view this content.

[mkvassh]

Great. It works... Thanks a lot :-)