I’ve used the date range formula to calculate the number of business days between two dates. @BusinessDays(StartDate;EndDate;1:7)
So if I’m out of the office Thur-Tue it is only calculating 4 days.
My problem is in the displaying, it is showing on Thur, Fri, Sat and Sun. I need it to display on Thur, Fri, Mon, Tue. Excluding Sat and Sun.
Can anyone help me with this problem. I’ve searched the forums and couldn’t find an answer to the display problem.