Selecting data in a specific date range using COUNTIFS function
 

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.

Selecting data in a specific date range using COUNTIFS function
 

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))
--
If this post helps click Yes
---------------
Jacob Skaria


"Joe R @ AA" wrote:

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.