| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
count records in a date range
I have a worksheet in which I am trying to count the number of records in a
date range. For example, the Submit_Date column contains the following dates/times (cells a1:a5): 12/17/2005 12:00:54 PM 12/16/2005 1:00:54 PM 12/17/2005 9:00:13 PM 12/10/2005 7:54:16 AM 12/17/2005 10:04:11 AM I would like to count the number of records with a Submit_Date between 12/1/2005 12:00:00 PM and 12/31/2005 11:59:59 PM. Any suggestions? -- Jim -- Jim |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
| Counting unique records based on date range | Excel Worksheet Functions | |||
| count weekdays in a date range | Excel Worksheet Functions | |||
| How can I sum information in a list with a date range? | Excel Worksheet Functions | |||
| Excel: How to return count for each cell within date range criter. | Excel Worksheet Functions | |||
Threaded Mode
