title: SQL Date Diff Business Days
body: <p>I need to count all orders that have a datediff  &lt;= 1. I use the COALESCE function, because sometimes the Date1 can be null. </p>
  
  <pre><code>SELECT COUNT(*)
  FROM Orders
  WHERE DATEDIFF(dd,COALESCE(Date1, Date2),Date0) &lt;= 1
  </code></pre>
  
  <p>Is there a way I can count only the business days (Mon-Fri)?</p>
  
  <p>Thanks.</p>