Find number of business days in a date range

  1. Calculate the difference in days by datetimediff()
  2. generate rows from 1 to difference in days for each range
  3. create a formula to add the number in (2) to starting date by datetimeadd()
  4. change the date format to day of the week
  5. filter Sunday & Saturday