Hello,
I am trying to find the largest date between cells EO5 & ET5. I need to exclude anything with the value of "Canceled/Closed" or "Closed" and make the result blank if any of the cells between EO5 & ET5 are blank.
=MAX(IF(EO5:ET5<>"", W5<>"Canceled/Closed", W5<>"Closed", EO5:ET5)
This resulted in "You've entered too many arguments for this function"
Any assistance would be greatly appreciated.
Bookmarks