Using COUNTIF and NOW() together
COUNTIF(B5:B100,"="&TODAY())
"Jock" wrote:
Having problems with this one.
Column B has sequential dates entered. I would like to find out how many are
today's date so I tried this:
COUNTIF(b5:b100,=now())
Results in 0 as Excel changes it to this: COUNTIF(b5:b100,"=now()") and
looks for text.
Any ideas?
--
tia
Jock
|