Here is my problem:

I have an Order Date. I am trying to generate a Ship Date based on this Order Date. If the Order Date is Mon-Thur, the formula would just be Order Date + 1. However, if the Order Date is a Fri, it is Order Date +3; Sat, it is Order Date +2; Sun, it is Order Date +1.

=IF(WEEKDAY(L2,2)=6,L10+3)
So basically I want to incorporate three things into the formula:

If Order Date = 6 (Fri), Order Date +3
"         "        = 7 (Sat), Order Date +2
"         "        = 1 (Sun), Order Date +1
If Order Date = 2 (Mon),3(Tue),4(Wed),or 5(Thu), Order Date + 1
Any suggestions on how to accomplish this? I can do three different formulas but I was trying to see if I could do it all together.

Thanks