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.
|