I want to see if the greater of [date1] and [date2] is less then today.

Currently i have it for one column - =IF([date1]<TODAY(),"Yes","")

But how do I make this formula to include the logic of using the greater of date1 and date 2?


1 Answer 1


Use the MAX function

=IF(MAX([date1], [date2])<TODAY(),"Yes","")

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.