| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pulling Data that falls within a specific date range? | Excel Worksheet Functions | |||
| Selecting specific row/column from a named range | Excel Worksheet Functions | |||
| Selecting date specific data from different spreadsheets | Excel Discussion (Misc queries) | |||
| Selecting data within a date range | Excel Worksheet Functions | |||
| Help! Selecting data according to date range | Excel Discussion (Misc queries) | |||
![Joe R @ AA[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
