If your data is in A1:A6000 then one way is to put your 2 dates in cells E1
and E2 and then use
= COUNTIF(A1:A6000; "<" & E2) - COUNTIF(A1:A6000; "<" & E1) - 1

You might want to check on the "<" versus "<=" and the "-1" at the and. Is a
little dependant on if you wish to in- or exclude the boundaries.

Good luck
JP


"ejb030353" schreef in bericht
...
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