Is it possible?

[DW]

I have a large worksheet upon which each line carries a
date, expresssed as MM/DD/YY (in a column titled "date
case opened"). I would like to know if there is a formula
that would count the number of cases opened between to
specific dates. Has anyone got advice?

 

[Paul B]

DW, try something like this, counts the number of days that are between the
dates in E1 & E2, this is an array formula, so must be entered by CSE (ctrl
+shift+enter)

=COUNT(IF((B2:B100>=$E$1)*(B2:B100<=$E$2),B2:B100))

Or this for hard coded datas, also and array formula
=COUNT(IF((B2:B100>=DATEVALUE("5-24-2003"))*(
B2:B100<=DATEVALUE("6-28-2003")), B2:B100))
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2000 & 97
** remove news from my email address to reply by email **

 

[Peo Sjoblom]

One way

=COUNTIF(Range,">="&DATE(Year,Month,Day))-COUNTIF(Range,"<="&DATE(Year,Month
,Day))

another

-SUMPRODUCT(-(Range>=DATE(Year,Month,Day)),--(Range>=DATE(Year,Month,Day)))

so if the dates between are

10/01/03 and 11/30/03 the date function should look like

DATE(2003,10,1) and DATE(2003,11,30)

and Range is obviously the range where your opened cases date are

 

[Biff]

Just to add a little:

To add more functionality and make the formula shorter at
the same time, replace the DATE() function with a cell
reference.

Biff

 

[DW]

-----Original Message-----
I have a large worksheet upon which each line carries a
date, expresssed as MM/DD/YY (in a column titled "date
case opened"). I would like to know if there is a formula
that would count the number of cases opened between to
specific dates. Has anyone got advice?
.
Have tried all the suggestions and I still can't get the

result I need. Getting to tired to think straight. Will
try again tomorrow. Thanks for the help. Good night.