Count dayname equal to

I have a range with dates and I want to count dayname equal to mon, tue, wed.....sun.

I use a user defined function like the one below, but it is difficult to get this one to work together wiht COUNTIF.

Any suggestion?

Please Login or Register  to view this content.

Not sure you really need a UDF here - it will generally perform slower than native functions...

=SUMPRODUCT(--(WEEKDAY(range)=1))

would give count of Sundays though assumes all values within range are valid dates, if not,

=SUMPRODUCT(--(TEXT(range;"dddd")="Sunday")))

amend per own local requirements

Hi,

Would this work for you?

=SUMPRODUCT((WEEKDAY(A1:A25)=daynumber)*1)

where dayname is a number between 1 and 7 representing sunday to saturday.

-----------------------------------------------