Calculate business days between 2 dates

[ahaiba]

@Xiphware

To exclude weekends you cannot just subtract 2 for every week between the two dates, since it’ll also depend on whether the first/last dates lie on a weekend. So you’ll need to determine whether the first and/or last day are Saturday/Sunday. Have a look at this posting; although it is about weeks, it describes the tools necessary:

Calculating week-of-year for a date - Showcase - ODK Forum

In particular, format-date(${date},"%a") will give you the day-of-week for a date (from which you can determine the needed Sat/Sun…)

Good luck. Please post your solution here when you’ve solved it.

Hello, thanks but I have tried to use your solution and I couldn’t get the desired output. would you please share your code?