And If formulas with date ranges

Hello, I am reaching out to the community for assistance.

I am trying to do a date range formula.

This following works:

=IF(ISBLANK([74. Discharge date]@row), "No Discharge",

IF([CRM 30 Day Done]@row = 1, "OK",

IF([74. Discharge date]@row > TODAY(+15), "", IF([74. Discharge date]@row < TODAY(+31),

"Past Due"))))


This is where I am trying to get now:

=IF(ISBLANK([74. Discharge date]@row), "No Discharge",

IF([CRM 30 Day Done]@row = 1, "OK",

IF(AND([74. Discharge date]@row > TODAY(+15), IF([74. Discharge date]@row < TODAY(+31)), “”,

IF(And[74. Discharge date]@row > Today(+32), "Past Due", IF([74. Discharge

date]@row < TODAY(+89)), “Past Due”,

“”)))))

Thank you for whoever takes the to share your thoughts!!!!

Answers

  • Carson Penticuff
    Carson Penticuff ✭✭✭✭✭✭

    I am going to need a little clarification.

    You list TODAY() with several positive numbers but have past dates in your screenshot. Are you wanting to show how far into the past or how far into the future the discharge dates are? Your screenshot would suggest past, but the formulas suggest future.

    In the event the checkbox is not checked, I see results listed for:

    Between 15 and 31 days = Past Due

    Between 32 and 89 days = Past Due

    What should the results be for less than 15 days and for more than 89 days?