Calculate Working Days (Business Days) between a Date Range

[felipe]

Hello all,

Has anyone came up with an idea how to calculate the working days between two dates (start and finish)? Something similar to networkdays() formula in excel?

Thanks

[romanmg]

If you use the Air Date/Time Picker plugin, you can enable Multiple Dates and also Date Range.

A simple text element can then use the value of a selected range in this picker: “Air Date/Time Picker’s value list:extract day:filtered:count”

See below. Basically, the text expression is saying “list out all the dates in the range, extract the day of the week for each, filter out any 6s and 0s (Sat & Sun), and count the remaining numbers (days)”

---

Gaby | Coaching Bubble
Private coaching, courses, and tons of free resources

[veshoe231]

@romanmg ur just awesome for the bubbles…

“A HERO”

very grateful for all the time & knowledge UV shared

[felipe]

Thank you @romanmg!!! Superhero, as usual.