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
-
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?
Categories
- All Categories
- 14 Welcome to the Community
- Customer Resources
- 64.8K Get Help
- 434 Global Discussions
- 138 Industry Talk
- 470 Announcements
- 4.9K Ideas & Feature Requests
- 129 Brandfolder
- 148 Just for fun
- 65 Community Job Board
- 486 Show & Tell
- 33 Member Spotlight
- 2 SmartStories
- 300 Events
- 36 Webinars
- 7.3K Forum Archives