Need to ignore text (NA) in cell referenced in a formula
I have the following formula to determine Status:
=IF(OR(TODAY() > [Due Date1]@row, TODAY() > [ Due Date2]@row, TODAY() > [Due Date3]@row, TODAY() > [Due Date4]@row), "Red", "Green")
It works as expected when dates are entered into the referenced Due Date cells. However, if text (NA) is entered, I get a #INVALID OPERATION error.
Is there an operation to ignore NA if it is in ANY of the Due Date cells?
Help Article Resources
Check out the Formula Handbook template!