Compare 2 columns to find max date, then compare to 3rd column to find True or False

Hi All,

So I have 3 columns that could have dates, Column Q is my completed date this is what I need to compare the other columns to. Column M and Column P have estimated time of completion dates, and column P may be blank.

Essentially what I need this statement to say is:
If P1 = "",
Then Q1 <= M1, "0", "1"

If P1 <> "",
Then Q1 <= P1, "0", "1"

Thank you in advance for any help!!!!

Try this:

=IF(P1="",IF(Q1<=M1,0,1),IF(Q1<=P1,0,1))

You can put the quotes around the 0 and 1 if you want them returned as text values.

Hope this helps.

Pete

Thanks Pete. What if I need to add in a piece to say if Column M contains the word "Closed"??

What do you want to happen if it does contain "Closed" ?

Pete