sum all values which = y if they fall in the month of a date typed in b1

[roster]

I have 2 worksheets reports and database([Table5).

I want to search [Admit Sections complete] and count the number of y found for the entire month if I type in the end of the month as a single date.

I've used =MONTH(B1) in c1 and Year(B1) in d1

this is as far as I have gotten but it is no working

=SUMPRODUCT((MONTH(Table5[Day Surgery Date])=$C$1)*(YEAR(Table5[Day Surgery Date])=$D$1),Table5[Admit Sections complete])

any help would be greatly appreciated

cheers

 

[steve the fish]

I cant test but maybe this:

=countifs(Table5[Day Surgery Date],">="&eomonth(b1,-1)+1,Table5[Day Surgery Date],"<"&eomonth(b1,0)+1,Table5[Admit Sections complete],"y")