Help with counting multiple conditions

[Guest]

I have one column with many dates in the 4/27/2007 format.

I need to count how many dates are with the ranges of:

4/2/2007 - 4/8/2007
4/9/2007 - 4/15/2007
4/16/2007 - 4/22/2007
4/23/2007 - 4/29/2007

I need to have a number for each range.
Can anyone help me?

Thanks

 

[Dave Peterson]

Create a small table with the start date in the first column and the end date in
the second column (say x1:y5).

Then with the dates in A1:A100, you could use a formula like:
=countif(a1:a100,">="&x1) - countif(a1:a100,">"&y1)

and drag down.

 

[Guest]

I didn't explain well enough. Here is a small example of what I am looking for.

Customer PAM

Walmart 4/2/2007
Sams 4/15/2007
Walgreens 4/7/2007
Best Buy 4/23/2007
Circuit City 4/11/2007
HEB 4/5/2007

4/2/2007 - 4/8/2007 = 3
4/9/2007 - 4/15/2007 = 2
4/16/2007 - 4/22/2007 = 0
4/23/2007 - 4/29/2007 = 1

I need a integer answer not a date answer, and I don't want to count all of
the dates. I just want to count the dates within a specific range.

Thanks again.

 

[Dave Peterson]

If you see a date as the result of that suggested formula, then format it as
general.