Check two dates against todays date?

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

replace TODAY with today() ( XL has a help function, use it)

SOLVED: Needed to enter TODAY with ()

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

Thanks for all the answers. But I have a new problem which makes my formula more complex.

I also want to check if cell B2 or cell C2 have a date value. In some cases these cells can have a #N/A value. If so is the case I dont won't the formula to check these cells. I want the formula only to check the cell with a date and then check if this date is later than today.

I have uploaded a file that explains better

zbor, no I didnt try your formula. But when I did it worked like a charm

Thanks a lot!

Originally Posted by zbor

Did you test my formula?

Also, for #N/A maybe you could solve cause of what making you error.

It seems like I was a bit hasty. It seems like the formula works when the value of the cell is a standard text, but as soon as the value of one of the cells is #N/A the formula will only show you #N/A despite one of the cells having a date value later than today.

Is it perhaps possible to check if a cell contains a date value? If it contains a date value I can get this value and transfer it to another cell and then do the operation in two steps?

Originally Posted by zbor

It's possible, but can you remove error from your previous cell?

In other words what cause you error?

If some formula return you error in xl 2003 you can use:

=IF(ISERROR(formula), "", formula)

So this one will work. But we would need know more about what causing error

Ok. The error is caused by a =vlookup formula. I am checking to se if a value is present in another sheet. If the value is noe present the vlookup formula sends away a #N/A error message. Can i maybe make the vlookyp formula to give me anther value if value looked up is not found?

Originally Posted by zbor

You can do this: =IF(ISNA(MATCH( value, vlookup_array, 0), "No match found", VLOOKUP(...))

I finally solved it

I used a combination of your two suggestions.

I used this one to to make my =vlookup into 0 if #N/A
=IF(ISNA(VLOOKUP(AE2;CRM!$A$31:$F$84;6;FALSE));0;VLOOKUP(AE2;CRM!$A$31:$F$84;6;FALSE))

And then I compared the two dates against each other using the formula under:

=IF(MAX(AI2:AJ2)>TODAY();"TRUE";"FALSE")

Thank you very much!