=SUMPRODUCT(--(A2:A1000=DATE(2005,04,01)),--(A2:A1000<=DATE(2005,04,20))

If you are just looking for a month, you can use

=SUMPRODUCT(--(MONTH(A2:A1000)=4))

or if there can be multiple yers, then

=SUMPRODUCT(--(YEAR(A2:A1000)=2005),--(MONTH(A2:A1000)=4))

or

=SUMPRODUCT(--(TEXT(A2:A1000,"yyyymm")="200504")

--

HTH

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


"Bugaglugs" wrote in message
...
In column A I have dates in the following format;
01-Apr-05 right through until the end of March 2006
On a different sheet in my workbook I want to summarise the information
by
counting the number of appointments between certain dates to get monthly
totals. I just don't know how to say that I want all dates between
01-Apr-05
until say 30-Apr-05p and so on. Is it possible to do this - the formula I
was trying with was;
=COUNT(IF('Master
Sheet'!$A$2:$A$10000=DATEVALUE("01/04/2005:30/04/2005"),1,0))
But this isn't working!