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!