Is it possible?

  • Thread starter Thread starter DW
  • Start date Start date
D

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?
 
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 **
 
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
 
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
 
-----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
Click to expand...
result I need. Getting to tired to think straight. Will
try again tomorrow. Thanks for the help. Good night.
 
Back
Top