count records in a date range

[Guest]

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?

 

[Guest]

You can use SUMPRODUCT

=SUMPRODUCT((A1:A100>=B1)*(A1:A100<=B2))
A1:A100 ....date range
B1 start date
B2 end date

HTH
JG

 

[Bob Phillips]

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)

 

[Guest]

Got it figured out, thanks for the help!
--
Jim

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)