Put your start date in C1, and your end date in D1, and try this:

=SUMPRODUCT((A1:A100=C1)*(A1:A100<=D1))
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Andrew82" wrote in message
...
I have a column of submission dates in the format 01/01/05, and I need to
count the occurances of dates between certain values... for example, count
how many submissions there were between 02/01/05 and 09/01/05