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

Jock


"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