Say your list starts in A1.
In B1 enter
jan
and copy down to B12 to create a list of unique months.

Then in C1, enter this formula:

=COUNTIF($A$1:$A$100,TEXT(B1,"mmm"))

And copy down to C12.
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Nhernandez" wrote in message
...
I need a formula that would look into a range of Dates and count how many
values I have for each month.

Example:

Date Results
1-Jan January 3
2-Jan Feb 4
3-Jan Mar 1
1-Feb Oct 2
7-Feb
9-Feb
10-Feb
5-Mar
1-Oct
2-Oct