How many times day occurs in a month

[djl0525]

In B2, I have a date.

In AV2, I need to know how many times the day of the week (in the date) occurs in the month.

Any help will be greatly appreciated.

DJ

 

[Scott T]

Try

=1+INT((EOMONTH(B2,0)-(EOMONTH(B2,-1)+1+MOD(WEEKDAY(B2,1)-WEEKDAY(EOMONTH(B2,-1)+1),7)))/7)

 

[Scott Huish]

Also:
=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(EOMONTH(B2,-1)+1&":"&EOMONTH(B2,0))))=WEEKDAY(B2)))

 

[Scott R]

Okay here's an original (I think):
=SUMPRODUCT(--(MONTH(B2+7*(ROW(1:9)-5)) = MONTH(B2)))

 

[Scott Huish]

Wow, 3 Scotts replying

 

[barry houdini]

=SUMPRODUCT(--(MONTH(B2+7*(ROW(1:9)-5)) = MONTH(B2)))

I like that

Wow, 3 Scotts replying

Room for a "barry"?

Try this, formatted as general

=4+(DAY(B2+28-FLOOR(DAY(B2)-1,7))>7)