In a set of dates, can you count the number of Jan '07 instanc
Thanks for your help. This is exactly the function I needed.
--
Linda W
"Duke Carey" wrote:
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
|