SQL Date Diff Business Days
<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>