IF Statement subtracting Dates

Brandon03Brandon03
edited 09/24/21 in Formulas and Functions
09/24/21 Edited 09/24/21
Accepted

Best Answer

Answers

  • Jason DuryeaJason Duryea ✭✭✭✭✭

    Hopefully I read the field names in your screenshot correctly.

    =IF([OK/NG CM]@row <> "CLOSED", Today - [CM DUE DATE]@row, 0)

  • Returning unparseable...also I need if closed is anywhere in that cell

  • Brandon03Brandon03
    Accepted Answer

    Got it

Sign In or Register to comment.