Calcuate dates between excluding holidays

[PIVOTGURU]

I have been reading blogs for a good part of the day trying to solve what I'm sure is an easy answer, to no avail. I'm using the following formula currently and it's working appropriately and now trying to incorporate a Holiday table. I want it to calculate the number of days between [order date] and [line actual ship date] excluding weekends and holidays. I'm using a Basic Calendar feed and linked "holiday" table. I've identified holidays with a "-1" using =RELATED(Holiday[Holiday])*1 in the table I want to do the calculation. Any help would be greatly appreciated! =CALCULATE(SUM(BasicCalendarUS[Weekday]),DATESBETWEEN(BasicCalendarUS[DateKey],SOP30300[Order Date],SOP30300[Line Actual Ship Date]))