countif function using dates
Will not work if the month is January and if there happens to be some blank
cells
included.
--
Regards,
Peo Sjoblom
"Teethless mama" wrote in message
...
=SUMPRODUCT(--(MONTH(M3:M158)=10))
"Cassidy1" wrote:
I want to calculate the number of entries in a column that are later than
one
date and earlier than another.
This is what I thought would work, but doesn't:
=COUNTIF(M3:M158,"30/09/2007"&"<01/11/2007")
|