When using creating a calculated field using the weekday parameter, the output does not remove weekend days.

DateDiff("w", [Date1], [Date2])

Example: 7/2/2020 - 7/7/2020 should be 4, but the output is 5.

Any ideas?

Comments