How do I count cells in a column of dates between date ranges?
 

I have a column of submission dates in the format 01/01/05, and I need to
count the occurances of dates between certain values... for example, count
how many submissions there were between 02/01/05 and 09/01/05

Put your start date in C1, and your end date in D1, and try this:

=SUMPRODUCT((A1:A100=C1)*(A1:A100<=D1))
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Andrew82" wrote in message
...
I have a column of submission dates in the format 01/01/05, and I need to
count the occurances of dates between certain values... for example, count
how many submissions there were between 02/01/05 and 09/01/05

Andrew82 wrote:
I have a column of submission dates in the format 01/01/05, and I need to
count the occurances of dates between certain values... for example, count
how many submissions there were between 02/01/05 and 09/01/05

=COUNTIF(DateRange,"="&X2)-COUNTIF(DateRange,""&Y2)

where X2 houses a date like 02/01/05 and Y2 a date like 09/01/05 with X2
<= Y2.