Hi,

Put this in a cell and drag dwom 11 rows to get a monthly count for each
month of 2009

=SUMPRODUCT(--(MONTH($A$1:$A$30)=ROW(A1)),--(YEAR($A$1:$A$30)=2009))

Change range to suit.

Mike

"Dilly" wrote:

Could somebody please assist with a formula to count the number of dates in
February 2009 for example, from a "long" list of random dates.
We have a helpdesk function that logs calls and am trying to establish how
many calls we received in February 2009