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.

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.

Try this:

=COUNTIF(Presentations,"="&DATE(2008,3,1))-COUNTIF(Presentations,""&DATE(2008,3,31))

Better to use cells to hold the date boundaries:

A1 = lower date boundary = 1/3/2008 (d/m/y)
B1 = upper date boundary = 31/3/2008 (d/m/y)

=COUNTIF(Presentations,"="&A1)-COUNTIF(Presentations,""&B1)

If you want to count for a specific month and the dates all fall within the
same year, or the year doesn't matter:

=SUMPRODUCT(--(MONTH(Presentations)=3))

Counts all dates in the month of March of *any* year.

--
Biff
Microsoft Excel MVP


"majestyk" wrote in message
...
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.