Combining IF(AND statements with Dates

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

Tagged:

Best Answer

Answers

Sign In or Register to comment.