I think this formula will get you the numbers you're looking for:
DATEDIFF('weekday', [start_date], [end_date])
- 2 * (DATEPART('week', [end_date]) - DATEPART('week', [start_date]))
+ (IF DATENAME('weekday', [end_date]) = 'Saturday' OR DATENAME('weekday', [start_date]) = 'Sunday'
This KB article might be helpful too if you want to explore some more options with excluding days:
The code which you have sent is perfectly worked for us
Your help is much appreciated
1 of 1 people found this helpful
Great to know it works as common solution.
Thank you for the feedback.
Could you mark my answer as correct, if you think it's solved.