Count date cells for specific month

Hi all,

I am trying to count a data range of dates to see how many of the fields have dates for a specific month.

I currently have the below, but it is displaying a #VALUE! error as there are some blank fields within the data range. I have tested without the blanks and it works fine.

=SUMPRODUCT(1*(MONTH(A4:A81)=F1))

A4:A81 is the data range of dates
F1 cell is showing a month number, 3 for example.

Please help!

Kind regards,
Brad

bauvache,

Can't see your table? But If Data is in Col A and a DATE is in F1 (any date in the month will do), put this in G1:

=COUNTIFS($A$4:$A$81,">="&EOMONTH($F1,-1)+1,$A$4:$A$81,"<="&EOMONTH($F1,0))

(To ensure you count every day in whatever month you enter in F1, count records dated on or after the last day of the previous month plus one day (so first day in this month) and on or before the end of the month in F1)

Ochimus