Complex IF OR AND

[firehousetk]

Really stumped. How would this write:

If Substrate = Paper or Plastic or Glass
and Day Of The Week = 2 or 3 or 4
and the Time is 10PM
then Due Date = Date + 2


This is how I wrote out the following code, I just can't seem to understand the OR of the Day of the Week:

If Substrate = Paper or Plastic or Glass
and Day Of The Week = 6
and the Time is 10PM
then Due Date is Date + 4

=IF(AND(OR(G9="Paper",G9="Plastic",G9="Glass"),C9=6,F9="10pm"),E9+4,E9)

[Whizbang]

=IF(AND(OR(G9="Paper",G9="Plastic",G9="Glass"),OR(WEEKDAY(C9)=2, WEEKDAY(C9)=3, WEEKDAY(C9)=4),F9="10pm"),E9+4,E9)