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

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.



jstro01 wrote:

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

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" wrote:

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.



jstro01 wrote:

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

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

jstro01 wrote:

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" wrote:

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.



jstro01 wrote:

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


--

Dave Peterson