try
=SUMPRODUCT(--(daterangeDATEVALUE("12/31/2006")),--(daterange<DATEVALUE("2/1/2007")))

"Linda Woodfield" wrote:

I have a column of dates where I need to count the number of instances that
fall within Jan 1 to Jan 31 2007. I have tried to use the countif function
and can only count values greater than a value or less than a value, but not
between two values. Is there another way?
--
Linda W