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

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

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

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