title: How to write expression to display ONLY business days within 5 day frame
body: <p>I am working on a report in Microsoft SQL Server Report Builder and I am trying to write an expression that will display only the next 5 business days from today (i.e. a table has 5 columns and it starts from today and proceeds for the next five business days). If the day is a Saturday or Sunday, which using my <a href="http://msdn.microsoft.com/en-us/library/82yfs2zh%28v=vs.80%29.aspx" rel="nofollow">enumeration value</a> would return a 6 or a 7 using the <code>Weekday</code> function, you would skip ahead to the next business day. Currently I have this expression for the first column after the column with today's date</p>
  
  <pre><code>IIf(Weekday(DateAdd("d",1,Today()),2)=6,DateAdd("d",3,Today()),
  (IIf(Weekday(DateAdd("d",1,Today()),2)=7,DateAdd("d",2,Today()),
  DateAdd("d",1,Today()))))
  </code></pre>
  
  <p>and it doesn't work. I believe this is because if we have a day like Wednesday, Thursday, or Friday, not enough days are being skipped over for the weekend days.</p>