OR

=SUMPRODUCT(--(TEXT(A1:A1000,"mmyyyy")="022009"))

If this post helps click Yes
---------------
Jacob Skaria


"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