Selecting data in a specific date range using COUNTIFS function

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

Jacob Skaria

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Creating a Chart on form from selected data in query. 0
countifs Function not giving desired result with date criteria 2
Multiple arguments 3
Using <= in countifs statement 1
Need Help with a VBA subroutine 0
Macro to Select text from a point given to a specific word 2
Excel 2010 countifs for date range 3
Use TODAY() function as the criteria in a SUMIF formula 1

Top