Cheers Bob. That's solved the problem and a lot of frustration in endlessly
trawling through excel help.

"Bob Phillips" wrote:

=SUMPRODUCT(--(MONTH(A1:A20)=2)

or

=SUMPRODUCT(--(TEXT(A1:A20,"mmm")="Feb"))

--

HTH

RP
(remove nothere from the email address if mailing direct)


"davidm" wrote in message
...
I have a list of dates and wish to count the number of times February
appears. If I search for a specific date such as 03 February 2005 I have
no
problem but if I wish to find all values containing part of the cell, in
this
case the month, I become stuck.