I need to count the number of cells in a column with a date that falls in a specific month, but the cell in another column on the same row must equal something specific as well.
More specifically, I need to count the number of dates that fall within the month for each specific group.
The date column is formatted as 'm/d/yy h:mm AM/PM'. I do not care about the time, only the date, but do not want to have to modify that if possible.
I need to make sure that blank cells are not counted at all.

I have attached a sample. The actual file is much larger. I would like the count to appear in column F.
If correct, cell F2 would display the number 2, because only two users in Group 1 have a date listed.

Thanks for your help!
Sample date count report.xls