And If formulas with date ranges

Brett L

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!!!!

Find more posts tagged with

Accepted answers

All comments

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?

Sign in to join the conversation!

Quick Links

Component react.discussion.discussions had an error.

ref must be one of: categoryID, siteSectionID, category, category/categoryID, category/name, category/description, category/url, category/allowedDiscussionTypes, locale, siteSection, siteSection/basePath, siteSection/contentLocale, siteSection/sectionGroup, siteSection/sectionID, siteSection/name, siteSection/description, siteSection/apps, siteSection/attributes, layoutViewType, discussionID, commentID, page, latest, sort, sortType, lookupSort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.