View Single Post
  #2   Report Post  
Duke Carey
 
Posts: n/a
Default

Put your test dates in a cell, then use COUNTIF like so

=COUNTIF(A5:A30,"<="&A1)-COUNTIF(A5:A30,"<="&A2)



"Annie" wrote:

How would I indicate that I want to count the number of dates fall
between Date A and Date B? I looked in the other message threads about
subtracting one COUNTIF from another, but I don't think it works for
dates.

Thank you,
Annie