countif function using dates
It worked! Thanks very much Pete.
"Pete_UK" wrote:
Try it this way:
=COUNTIF(M3:M158,"30/09/2007")- COUNTIF(M3:M158,"=01/11/2007")
Hope this helps.
Pete
On Oct 12, 10:20 pm, 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")
|