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)

1 Like