=sumproduct((year(a2:a22)=2007)*(month(a2:a22)=1))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"MikeG" wrote in message
...
I would like to count the numbers of entris in a column that have the same
month and year. Each value has a date defined as mm/dd/yyyy.

Ex. how many entries are there for January 2007?

do I use countif?