Selecting data in a specific date range using COUNTIFS function

  • Thread starter Thread starter Joe R @ AA
  • Start date Start date
J

Joe R @ AA

I am having difficulty getting my COUNTIFS formula to select data from a
specific date range. I am looking for data based on a > or < date criteria.
All my returns come back as zero.
 
The below formula will return dates between May15th2009 and May1st2009 from a
colum of dates in J1:J100..Will that help

=COUNTIF(J1:J100,"<" & DATE(2009,5,15))-COUNTIF(J1:J100,"<" & DATE(2009,5,1))
 
Back
Top