SUM data between two dates excluding weekends

hi. i want to sum across the next 5 working days  5 days added to the date 4/8/20 is 9/8/20 so excludes the 10/8/20 I have a dim_date table with a working_day flag. Does anyone have thoughts on a ...