Hey,

I have a issue I can't seem to get working. I have two cells that contain two different dates. I would like to check if any of these cells have a data later than today’s date. If any of the two have a later date than today I wanth it to say OK, if not NOT OK.
This is what I have tried:

=IF(OR(B2>TODAY;C2>TODAY);"OK";"NOT OK")

This gives me the #NAME? result.

How should I go about fixing this formula?

Thanks in advance!

Ole