If Now = A Cell Range Then Q
 

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

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

Not sure of what you've got in C12, but I assume you've entered a date such
as 12/16/04. Try int(now())=C1 -- I think this will cure the minutes and
hour problem that you suspect.

Art