how do I find quantity between some dates?
 

I need to find quantity of invoices between some period of time (one week)
from 21-09-09 until 27-09-09
invoice_No date
I-1245 26-09-2009
I-1347 21-09-2009
I-1518 20-09-2009
I-9988 28-09-2009
I-2697 22-09-2009
I-1812 20-09-2009
I-1325 15-09-2009
I-3698 27-09-2009

how do I find quantity between some dates?
 

=Countif(B2:B9,"=21-Sep-09") - Countif(B2:B9,"27-Sep-09")

-kc
*Click YES if this helps

"Jul" wrote:

I need to find quantity of invoices between some period of time (one week)
from 21-09-09 until 27-09-09
invoice_No date
I-1245 26-09-2009
I-1347 21-09-2009
I-1518 20-09-2009
I-9988 28-09-2009
I-2697 22-09-2009
I-1812 20-09-2009
I-1325 15-09-2009
I-3698 27-09-2009

how do I find quantity between some dates?
 

Thank you very much
for help

"KC" wrote:

=Countif(B2:B9,"=21-Sep-09") - Countif(B2:B9,"27-Sep-09")

-kc
*Click YES if this helps

"Jul" wrote:

I need to find quantity of invoices between some period of time (one week)
from 21-09-09 until 27-09-09
invoice_No date
I-1245 26-09-2009
I-1347 21-09-2009
I-1518 20-09-2009
I-9988 28-09-2009
I-2697 22-09-2009
I-1812 20-09-2009
I-1325 15-09-2009
I-3698 27-09-2009

how do I find quantity between some dates?
 

I need to find quantity of Letters between some period of time (one week)
from 21-09-09 until 27-09-09, which are not replied

Letter No Received Date Reply Date
L-255 21-09-2009
L-256 23-09-2009 25-09-2009
L-257 25-09-2009 27-09-2009
L-258 21-09-2009
L-259 22-09-2009 25-09-2009
L-260 26-09-2009