counting entries between two dates?

T

Todd

Hi I am tring to count how many entries I have between two dates. I have
been trying to use the countif function and can't get greater or less thans
to work with it.

My dates are in cells c88 (lowest to count) and c89 (highest to count).
The data is in column P

Also, I will need to do the same counting of dates but in two columns
instead after this is figured out.

=COUNTIF(P5:p86,C88) is what I have and of course its not right at all.


TIA

Todd
 
D

Domenic

Try the following formula...

=SUMPRODUCT(--(P5:p86>=C88),--(P5:p86<=C89))

Hope this helps
 
T

Todd

Thanks its not quite right. Both formulas are adding all the dates in the
column but not subtracting the dates over the range. It looks right to me
and I have tried typing the dates into the formula but haven't got it yet.
Any ideas?


Todd
 
A

Aladin Akyurek

Inclusive between count:

=COUNTIF($P$5:$P$86,">="&C88)-COUNTIF($P$5:$P$86,">"&C89)
 
T

Todd

Thanks, Here is the formula I am trying.

=COUNTIF($P$11:$P$40,">="&9/1/4)-COUNTIF($P$11:$P$40,"<"&9/30/4)
 
A

Aladin Akyurek

=COUNTIF($P$11:$P$40,">=9/1/04")-COUNTIF($P$11:$P$40,">9/30/04")
Thanks, Here is the formula I am trying.

=COUNTIF($P$11:$P$40,">="&9/1/4)-COUNTIF($P$11:$P$40,"<"&9/30/4)

[...]
Click to expand...
 
Top