Using COUNTIF and NOW() together

[Jock]

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?

 

[Teethless mama]

COUNTIF(B5:B100,"="&TODAY())

 

[Max]

Use TODAY() instead, and frame it up like this:
=COUNTIF(B5:B100,TODAY())

 

[Jock]

Thanks to both Teethless Mama (good name there) and Max
Job done

Jock

 

[Max]

welcome ..