Forget that, JP's solution much more efficient.

"Jack Schitt" wrote in message
...
There may be a more efficient solution. I have not tried this over 60K
records, but in my example the population range is contained in C15:C36,
the
lower bound date in C9 and upper bound in C10.

=SUMPRODUCT(--(C15:C36=C9),--(C15:C36<=C10))


"ejb030353" wrote in message
...
I have a date range that contains 60000 records, I need to count this
range
and return a value for the number found. i.e. number of records between
10/01/02 and 10/30/02