Tomcat,

Select all your dates (along with the heading), then choose Data / Pivot Table.... and press Finish.

Then drag the heading button to both the row and data areas, then right click the row area and
choose "Group..." and group by month.

You will get a count of the number of dates for each month (also separated by year...)

HTH,
Bernie
MS Excel MVP


"Tomcat" wrote in message
...
I have a spreadsheet with a column containing dates formatted as mm/dd/yyy
and they are in random order. I need to count how many of the dates in the
column are in January, February, March, etc. and come up with totals in
another set of cells. I have tried various functions like COUNTIF with MONTH
but I cannot seem to get the right combination. Anybody out there ever do
this type of thing?