Excel 2007 : counting the number of times a particular month is present in a column

This has to be super easy but I can't figure it out. dates are in dd-mmm-yy format and are in a single column. what formula can I use to count the number of times each month appears in the column? example data:

12-jan-10
20-jan-10
25-jan-10
25-feb-10
30-mar-10


jan=3
feb=1
mar=2

A Pivot Table would do this for you very quickly...

Set your Date Field as both Row Label and Date Field (set to Count)
Right click on a Date in the Row Label and choose "Group" select "Month" only.

Formula wise using the values as you have them you would need a SUMPRODUCT formula...

Assuming only dates/blanks exist in the range reviewed then, eg:

Please Login or Register  to view this content.

If it's possible non-numeric/non-blank value exist in the range then you would use:

Please Login or Register  to view this content.

Note were this the case then the Pivot route would not work either
(you would not be able to Group the field by Month)