=SUMPRODUCT(--(TEXT(A2:A100,"m")="5"))


"Shoelaces" wrote:

I have searched and do not see what I need. I think it is just that I don't
understand what I am reading.

I have a coumn of dates such as 5/7/2005, 5/23/2006, etc.

I would like to produce a table that counts the number of records per month
such as:
5-2005: 32
6-2005: 16
7-2005: 24
etc.

I am struggling on how to do this. A little hand holding would be
appreciated.

Thank you.