title: Declare date, then add next business day
body: <p>I'm not getting the results that I need.</p>
  
  <p>All I want to do is declare my date and then I want add the next business day to it.  ie. <code>@CASHDATE+1</code> (this works) but I need the next business day being 5th.</p>
  
  <pre><code>DECLARE  @CASHDATE DATETIME
  SET @CASHDATE='2016-12-02'
  
  SELECT &lt;&lt;COLUMN_NAME&gt;&gt;  FROM &lt;&lt;TABLE_NAME&gt;&gt; 
  WHERE RECEIVED_DATE = @CASHDATE /*'2016-12-02'*/ 
  AND TRANS_POST_DATE = @CASHDATE+1 /*'2016-12-05'*/) &lt;== I don't want it to be '2016-12-03 or 04', I'm trying to get the next business day. 
  </code></pre>
  
  <p>Any ideas on how to achieve this would be welcome.  I've been experimenting with <code>DATEPART(dw, @CASHDATE) NOT IN (1, 7)</code> but I just can't get the result I want.</p>