Thread: Selecting data in a specific date range using COUNTIFS function
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Jacob Skaria Jacob Skaria is offline
external usenet poster
  
Posts: 8,520
Default 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.
Reply With QuoteReply With Quote