Yes it is, use TODAY() rather than NOW().

--

HTH

RP
(remove nothere from the email address if mailing direct)


"John" wrote in message
...
I'm trying to write an IF formula that if NOW = a Date in a Range then,
but
its not coming out at the right answer. Has it anything to do with Hours &
Minutes within NOW.

Basically I want say if the date in NOW = C12 (which is defined
as16/12/04)
then "OK"


Thanks