Thanks that fixed it. Makes since.

"ShaneDevenshire" wrote:

Hi,

Try using =TODAY() instead of =NOW()

NOW track the date and time even if only the date is exposed.
--
Thanks,
Shane Devenshire


"sconstance" wrote:

I'm trying to do a simple If function of If A1=A2 then return a 0 and if
incorrect return a 1.

However A1 is a NOW formula for the date and A2 is just the date manually
entered. It keeps returning a 1 because of the formula in A1 even when the
output of A1 matches A2.

Is there a way to get the If function to read the output value of A1 instead
of the formula inside of the cell?