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