A number of options:
=SUMPRODUCT(--(A1:A11=DATE(2007,4,1))*--(A1:A11<DATE(2007,7,31)))
=COUNTIF(A1:A11,"="&DATE(2007,4,1))-COUNTIF(A1:A11,""&DATE(2007,7,31))
[and adjust the and = if applicable]
=COUNTIF(A1:A11,"="&--"1/4/2007")-COUNTIF(A1:A11,""&--"31/7/2007") if
you're confident in the unabiguity of the dates.
--
David Biddulph

wrote in message
ps.com...
Hello,

I have a column of dates like below in cells A1:A11.

10/04/2007
21/08/2006
10/04/2006
16/04/2007
28/02/2005
16/01/2006
20/05/2003
01/03/2005
28/02/2005
13/10/2003
26/06/2006

What I would like to do is put a formula in the cell below (say A12)
to look at the whole range (A1:A11) and then count the cells that have
a date between 01/04/2007 and 31/07/2007 (in the above example it
would return 2).

I'm not sure if I should be using SUMPRODUCT for this as I am not too
au fait with that and it's getting late in the day!!

Any help greatly appreciated.

Cheers,

Ant