software

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

You can use SUMPRODUCT

=SUMPRODUCT((A1:A100gt;=B1)*(A1:A100lt;=B2))
A1:A100 ....date range
B1 start date
B2 end date

HTH
JG

quot;jimlquot; wrote:

gt; I have a worksheet in which I am trying to count the number of records in a
gt; date range. For example, the Submit_Date column contains the following
gt; dates/times (cells a1:a5):
gt;
gt; 12/17/2005 12:00:54 PM
gt; 12/16/2005 1:00:54 PM
gt; 12/17/2005 9:00:13 PM
gt; 12/10/2005 7:54:16 AM
gt; 12/17/2005 10:04:11 AM
gt;
gt; I would like to count the number of records with a Submit_Date between
gt; 12/1/2005 12:00:00 PM and 12/31/2005 11:59:59 PM.
gt;
gt; Any suggestions?
gt; --
gt; Jim
gt; --
gt; Jim

Jim,

Try this

=SUMPRODUCT(--(A1:A5gt;=--quot;2005-12-01 12:00:00 PMquot;),--(A1:A5lt;=--quot;2005-12-31
11:59:59 PMquot;))

--

HTH

RP
(remove nothere from the email address if mailing direct)quot;jimlquot; gt; wrote in message
...
gt; I have a worksheet in which I am trying to count the number of records in
a
gt; date range. For example, the Submit_Date column contains the following
gt; dates/times (cells a1:a5):
gt;
gt; 12/17/2005 12:00:54 PM
gt; 12/16/2005 1:00:54 PM
gt; 12/17/2005 9:00:13 PM
gt; 12/10/2005 7:54:16 AM
gt; 12/17/2005 10:04:11 AM
gt;
gt; I would like to count the number of records with a Submit_Date between
gt; 12/1/2005 12:00:00 PM and 12/31/2005 11:59:59 PM.
gt;
gt; Any suggestions?
gt; --
gt; Jim
gt; --
gt; Jim
Got it figured out, thanks for the help!
--
Jimquot;Bob Phillipsquot; wrote:

gt; Jim,
gt;
gt; Try this
gt;
gt; =SUMPRODUCT(--(A1:A5gt;=--quot;2005-12-01 12:00:00 PMquot;),--(A1:A5lt;=--quot;2005-12-31
gt; 11:59:59 PMquot;))
gt;
gt; --
gt;
gt; HTH
gt;
gt; RP
gt; (remove nothere from the email address if mailing direct)
gt;
gt;
gt; quot;jimlquot; gt; wrote in message
gt; ...
gt; gt; I have a worksheet in which I am trying to count the number of records in
gt; a
gt; gt; date range. For example, the Submit_Date column contains the following
gt; gt; dates/times (cells a1:a5):
gt; gt;
gt; gt; 12/17/2005 12:00:54 PM
gt; gt; 12/16/2005 1:00:54 PM
gt; gt; 12/17/2005 9:00:13 PM
gt; gt; 12/10/2005 7:54:16 AM
gt; gt; 12/17/2005 10:04:11 AM
gt; gt;
gt; gt; I would like to count the number of records with a Submit_Date between
gt; gt; 12/1/2005 12:00:00 PM and 12/31/2005 11:59:59 PM.
gt; gt;
gt; gt; Any suggestions?
gt; gt; --
gt; gt; Jim
gt; gt; --
gt; gt; Jim
gt;
gt;
gt;