Index, Match of If, OR function?

I have been struggling trying to create a formula to return TEXT based on multiple criteria.

I have 4 columns for dates titled “Promise Date”, “Delivery Date”, “Cancelled Date” and “Return Date (Columns E, F, G & H). In column “I” (titled “Delivery Status”) I wanted to return text based on:

If only Promise Date entered then returns “Pending”

If Promise Date and Delivery Date are entered, then returns “Received”

If Promise Date and Cancelled Date are entered, then returns “Cancelled"

If Promise Date, Delivery Date, and Return Date are entered then returns “Returned”

If Columns E to H do not have any data, then Column I returns a blank cell


Note: I typed in results I want in Column “I”

See attached

Thank you very much, AliGW!!!!!!!!

I really appreciate that you gave my a start point and explanation/direction for me to complete the formula. Here is my result:

=IF(AND(E2<>"",COUNT(E2:H2)=1),"Pending",IF(AND(E2<>"",F2<>"",COUNT(E2:H2)=2),"Received",IF(AND(E2<>"",G2<>"",COUNT(E2:H2)=2),"Cancelled",IF(AND(E2<>"",H2<>"",COUNT(E2:H2)=3),"Returned",""))))

This Forum and Members are Awesome!

Thank you for the quick reply, Richard!!!

I tried the formula, but a window pops up stating "You've entered too few arguments for this function"

Thank again, AliGW.

Post set to "Solved"