title: Is there a query that can add only business days , I used Date Add function but its still counting weekends?
body: <p>I'm setting up web-page to display Date for scheduling. Currently I'm using Date-add to add 5 business days, using Week , but it still takes into consideration of the weekend.</p>
  
  <p>I've tried the following code below and it includes weekend</p>
  
  <p><code>select convert(varchar,dateadd(dw,5,getdate()),101)</code></p>
  
  <p>I'm expecting it to show 5 days from today not counting the weekend.</p>