=SUMPRODUCT(--(A:A<=--"2008-01-01"),--(A:A=--"2008-03-31"))

or if the dates are in other cells

=SUMPRODUCT(--(A:A<=M1),--(A:A=M2))

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"DK" wrote in message
...
I need to count the number of records between two specific dates. Using
excel 2007. Can anyone help?