how do I find quantity between some dates?

J

Jul

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
 
K

KC

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

-kc
*Click YES if this helps
 
J

Jul

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top