ok, not sure how to put an And within a countif statement but you can group
two countifs togther

Note that March 1, 2008 in Excel is 39508 and March 31, 2008 is 39538

So we can do

=COUNTIF(Presentations,"=39508")-COUNTIF(Presentations,"39538")

should work I hope

"majestyk" wrote:

I need to count the occurences of dates between a range, either a week or
calendar month. I have so far:
=COUNTIF(Presentations,AND("="&"1/03/08","<="&"31/03/08"))
(**dates are dd/mm/yyy for Australia**). I keep getting an answer of 0 where
it should be 7.