IF and Date with N/A

Sldollman

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

Hi,

See if this will work for you:

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

ker9

Hi,

See if this will work for you:

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

Sldollman

This worked! Thank you so much! :)