B
Ben
Column Z contains multiple dates ranging over 10 years. I am trying to count
the number of cells in Column A that are between two dates (e.g., 01/01/07 -
01/31/07.)
I tried using
=SUM((COUNTIF(Sheet2!Z:Z,"<01/31/07"))-(COUNTIF(Sheet2!Z:Z,">01/01/07")))
however, the count if not correct. The result is 3,172 via the above formula
which is wrong. Using a filter, I know the correct result is 56, but I
cannot correct my formula to reflect.
Many Thanks!
the number of cells in Column A that are between two dates (e.g., 01/01/07 -
01/31/07.)
I tried using
=SUM((COUNTIF(Sheet2!Z:Z,"<01/31/07"))-(COUNTIF(Sheet2!Z:Z,">01/01/07")))
however, the count if not correct. The result is 3,172 via the above formula
which is wrong. Using a filter, I know the correct result is 56, but I
cannot correct my formula to reflect.
Many Thanks!