IF and Date with N/A

Question

Hello,

I'm attempting to put to arguments together keep coming up with "Invalid argument".

Each of these work individually:

=IF((Date@row < TODAY(), 1, 0))

=IF(CONTAINS("NA", Date@row), 1, 0)

My goal is to check the "date" cell.  If it less than Today, check.  Or if it contains "NA" then check.

How do I put these together?

Thank you in advance!

Ker9 · Accepted Answer

Hi,

See if this will work for you:

=IF(ISDATE(Date@row), IF(Date@row < TODAY(), 1), IF(CONTAINS("NA", Date@row), 1, 0))