birhtday - counting

[roveout]

I have a column with birthday and month. How can I put in a cell the number of birthdays for a given month?

thanks

[daddylonglegs]

I have a column with birthday and month.

How does that look exactly, is it a column of dates?

[roveout]

2 columns:
Charity 24-Jun
Denise 3-Nov
Diana 25-Nov
etc.

[daddylonglegs]

Well if you just want the number of birthdays in September you can use a formula like this

=SUMPRODUCT(MONTH(B2:B100)=9)+0)

assuming dates in B1:B100

[roveout]

Thanks! (padding)