I want to count say how many Mondays we have from 2022-02-01 - 2022-03-01. I found smth like this: =SUMPRODUCT(WEEKDAY(B4:C4)=2) - B4 and C4 are the dates But it returns 0. I assume it only checks if specific date is the specific day. Any ideas how I can do this but for a date range? So how count how many Mondays there are in February I also found this

=NETWORKDAYS.INTL(B4;C4;"1000000")

but this returns 25

CodePudding user response：

You can take advantage of the

Obvs nul points for me again but for the record this could be generalised if you put the day number in C2 (e.g. 1 if you want to find Sundays, 2 for Mondays):

=floor((B2-(A2 7-weekday(A2,10 C2)))/7) 1