Try...

=SUMPRODUCT(--('Master Sheet'!$A$2:$A$10000=DATE(2005,4,1)),--('Master
Sheet'!$A$2:$A$10000<=DATE(2005,4,30)))

or

=SUMPRODUCT(--('Master Sheet'!$A$2:$A$10000-DAY('Master
Sheet'!$A$2:$A$10000)+1)=DATE(2005,4,1))

Hope this helps!

In article ,
Bugaglugs wrote:

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!