Have you considered a pivot table, grouping the dates by month? That may be a better
solution, particularly if your data spans more than 1 year, so you have Jan 2006 and Jan
2007.

Or you can try COUNTIF. Put the month numbers in say, B1:B12, this formula in C1, and copy
it down through C12:

=COUNTIF(A$1:A$100,"="&DATE(2007,B1,1))-COUNTIF(A$1:A$100,"="&DATE(2007,B1+1,1))

On Mon, 5 Nov 2007 11:33:03 -0800, Nhernandez
wrote:

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