Question: how to calculate number of days between two dates tableau?
Answer: (DATEDIFF('day',[Day1],[Day2]) - (7-DATEPART('weekday',[Day1])) - ...  (DATEDIFF('day',[Day1],[Day2]) Then we trim off days in the first partial week of the time frame. ...  - (7-DATEPART('weekday',[Day1])) ...  - DATEPART('weekday',[Day2]) ...  + MIN(5,(7-(DATEPART('weekday',[Day1])))) ...  + MIN(5,(DATEPART('weekday',[Day2])-1))