Combining IF(AND statements with Dates

Brad Dalrymple

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

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")

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