| 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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
count records in a date range
You can use SUMPRODUCT
=SUMPRODUCT((A1:A100=B1)*(A1:A100<=B2)) A1:A100 ....date range B1 start date B2 end date HTH JG "jiml" wrote: 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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
count records in a date range
Jim,
Try this =SUMPRODUCT(--(A1:A5=--"2005-12-01 12:00:00 PM"),--(A1:A5<=--"2005-12-31 11:59:59 PM")) -- HTH RP (remove nothere from the email address if mailing direct) "jiml" wrote in message ... 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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
count records in a date range
Got it figured out, thanks for the help!
-- Jim "Bob Phillips" wrote: Jim, Try this =SUMPRODUCT(--(A1:A5=--"2005-12-01 12:00:00 PM"),--(A1:A5<=--"2005-12-31 11:59:59 PM")) -- HTH RP (remove nothere from the email address if mailing direct) "jiml" wrote in message ... 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 |
| Reply |
| 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 | |||
Linear Mode
