Try this:

=SUMPRODUCT((MONTH(A1:A7)=7)*(YEAR(A1:A7)=2008))

Hope this helps.

Pete

On Jul 1, 1:30*am, Elaine wrote:
Hi Mike

I have tried that it appears as zero, so I tried it with as a wildcard and
no no luck still appears as zero

All the column has is this:

17/07/2008
15/07/2008
18/02/1900
18/02/1900
07/07/2008
18/02/1900
04/07/2008

Trying to pull out the number of July Performance reviews

--
Thanks for your support
Elaine



"Mike" wrote:
Maybe something like this
=COUNTIF(A1:A5,"july")

"Elaine" wrote:

Help,

Been working on this spreadsheet and it is starting to drive me Mad, I am
trying to count a column which it contains text and numbers, I am trying to
count every cell that contains the month July with no success.

I have tried wild cards and a pivot table, this give me a total of 6 when
there is only 4.

What am I doing wrong - please help
--
Thanks for your support
Elaine- Hide quoted text -

- Show quoted text -