Counting the number of Events that occur in a specific month in a range of days.

Good Day;
I am trying to figure out how to count the number of Events that have occurred for each month in a year and then place that number into another table which then gets graphed. This will cover five (5) years so I would like an easier way than what I have kluged together.

The only way I have been able to get it to work is to use a COUNTIF formula but I have to first convert the year and month I am interested from a date value (yyyy-mm) to a numerical date value and then manually enter those numerical date values into the COUNTIF formula.

This is my COUNTIF formula that I am using: =COUNTIFS($C$2:$C$23,">=41640",$C$2:$C$23,"<41671")

$C$2:$C$23 is the range of dates (in Date format yyyy-mm-dd).
41640 is 01 Jan 2014 in numerical date value.
41671 is 01 Feb 2014 in numerical date value.

Any ideas how I might do this?

I have attached my spreadsheet so you have a good idea of what I am trying to do.

Thanks for the help.


Kevin

pivot table?

in G:

=COUNTIFS($B$2:$B$23,">=" & E2,$B$2:$B$23,"<=" &EOMONTH(E2,0))

in H

=COUNTIFS($C$2:$C$23,">=" &E2,$C$2:$C$23,"<=" & EOMONTH(E2,0))


No need to convert dates as they are already numbers in Excel and it is comparing numbers when comparing dates.