Count Number of Each Month in Column of dates in Google Spreadsheet

Question

I have a Google sheet with a column of dates. I would like to get a total for each month, so that I can see how many of the dates are January, February, March, etc. This formula does not work (Dates is the name of range):

=COUNTIF(Dates,Month=1)

Any help is appreciated.

Answer 1

Following the logic of your proposition, the error is that MONTH() returns an integer, not an array. You can add ARRAYFORMULA() to do the job :

=COUNTIF( ARRAYFORMULA( MONTH( Dates ) ), "=2" )

Answer 2

I finally devised the correct search term for Google help

=sumproduct(month(Dates)=2)