Calculate net working days/business days between dates like Excel’s networkdays

Effectively this is a DateDiff with weekends excluded from the count of days:

DateDiff(“day”, [Start Date], [End Date]) - (DateDiff(“week”, [Start Date], [End Date]) * 2) + If(Weekday([Start Date]) = 7 and Weekday([End Date]) = 7, 0, Weekday([Start Date]) = 7, 1, Weekday([End Date]) = 7, -1, 0)

3 Likes

Note this will only exclude weekend days from the count. To exclude holidays or other non-work days, the best practice is to use a date dim table where those can be explicitly defined.