Try one of these:

C1 = 1/1/2007
D1 = 1/31/2007

=COUNTIF(A1:A25,"="&C1)-COUNTIF(A1:A25,""&D1)

=INDEX(FREQUENCY(A1:A25,C1:D1-{1,0}),2)

=SUMPRODUCT(--(A1:A25=C1),--(A1:A25<=D1))

Biff

"smore" wrote in message
...
I'm trying to figure out how many documents my office processes in a
particular month. The spreadsheet has columns with document names and the
dates the documents were processed. Is there any way to create a formula
that
will be able to count the number of occurrences of dates between, say
01/01/2007 and 01/31/2007 and give me that number so I can tell how many
permits were processed during the month?

All ideas *greatly* appreciated! :)