Counting events per month

[cpotts13]

I am trying to figure out this count function but am having some trouble.

I have many rows of events and Column A has the date in m/d/yy format.
I want to count the number of occurances for each month.
The function I tried was COUNTIF(A2:A512, "1/??/12") for January 2012
I then tried reformatting the date column to mm/dd/yy format making the criteria "01/??/12"
This didn't work. Any ideas?
I would really like this to work with just a formula I can copy down and without creating new rows or tables.

Here is an example of the data: https://www.box.com/s/jssyn7hen4yzybjrm5g1
The yellow highlighted area is where the issue is (Column M)

Thanks!

 

[Weazel]

maybe something like...

=SUMPRODUCT(--(MONTH(A1:A10)=MONTH(D1)))

assuming D1 contains the date of the month you are counting

 

[cpotts13]

Awesome Thanks!