title: Excel 2007 VBA If-THEN-ELSE Shipping Logistics
body: <p>I have a spreadsheet with 3 columns: <code>order type</code>, <code>order date</code>, and <code>target ship date</code>. There are 4 order types: <code>USA</code>, <code>USAPriority</code>,  <code>Canada</code>, and <code>Med</code>.</p>
  
  <p>Each order type only ships out on a certain date.</p>
  
  <ul>
  <li>USA order types can ship out 2 days after the order date,</li>
  <li>USAPriority ship next day after order date. </li>
  <li>Canada orders ship out the thursday of each week, if received by 11:59AM Wednesday, </li>
  <li>Med orders ship out the Wednesday of each week if received by 11:59AM Tuesday.</li>
  </ul>
  
  <p>I want to write a code that produces the target ship date based upon order type and order date.</p>