View Single Post
  #2   Report Post  
Aladin Akyurek
 
Posts: n/a
Default

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.