title: SSRS: Determining a Monthly Date Excluding Weekends
body: <p>I am trying to create a report that will generate a monthly date depending on the reporting month selected.  The due date is the 20th of the month, unless that date falls on a weekend or holiday.  I may be able to exclude the holidays but how do I write an expression to pull this?</p>
  
  <p>Parameters would be reporting month, as an integer, and reporting year.</p>
  
  <p>The person who created the report before me in Crystal used this formula:</p>
  
  <p>if DayofWeek({@Apr Due Date}) = 1 then  {@Apr Due Date} + 1  else
  if DayofWeek({@Apr Due Date}) = 7 then ({@Apr Due Date} + 2) else {@Apr Due Date}</p>
  
  <p>But I was trying to see if there was a way to do one expression to cover any month entered in the parameter.</p>
  
  <p>I am using Report Builder 3.0 and tsql.  Thank you in advance!</p>