Combining IF(AND statements with Dates

Hi -

I am trying to build a combined IF statement that takes a last contacted date and a last participated date and if both are true will output a status of "available". If not, it will be "not available". Separately, I can get the a formulas to work for each date, but once I combine the formulas, it fails.

First date formula:

=IF([Last Contacted]4 <= TODAY(-30), "Available", "Not Available")

Second date forumla:

=IF([Last Participation Date]4 <= TODAY(-90), "Available", "Not Available")

Combined:

=IF(AND([Last Contacted]4 <= TODAY(-30), [Last Participation Date]4 <= TODAY(-90), "Available", "Not Available"))

Thanks in advance for for any help!

--Brad

Find more posts tagged with

Formulas

Accepted answers

Paul Newcome

It is just a misplaced parenthesis. You want to close out the AND function within the first portion of your IF statement.

=IF(AND([Last Contacted]4 <= TODAY(-30), [Last Participation Date]4 <= TODAY(-90)), "Available", "Not Available")

All comments

Paul Newcome

It is just a misplaced parenthesis. You want to close out the AND function within the first portion of your IF statement.

=IF(AND([Last Contacted]4 <= TODAY(-30), [Last Participation Date]4 <= TODAY(-90)), "Available", "Not Available")

Brad Dalrymple

Fantastic. Thank you, Paul!

Paul Newcome

Happy to help! 👍️

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, sort, discussion, discussion/name, tags, breadcrumbs, discussionApiParams, serverDraftID, serverDraft.