Code can be found below the table. Alternatively, you can duplicate this page in the top right corner.

Remember to replace the names inside ALL of the prop( "Start") and prop( "End") in the formula to your respective property fields' names

Validated using: https://www.timeanddate.com/date/workdays.html

Does not work with holidays!

Business days

Formulas

Business days - no 'now'

Business days - automatic now v2

dateBetween(prop("End"), prop("Start"), "days") - dateBetween(prop("End"), prop("Start"), "weeks") * 2

Incl. end date - no 'now'

(dateBetween(prop("End"), prop("Start"), "days") - dateBetween(prop("End"), prop("Start"), "weeks") * 2 >= 0) ? (dateBetween(prop("End"), prop("Start"), "days") - dateBetween(prop("End"), prop("Start"), "weeks") * 2 + 1) : (dateBetween(prop("End"), prop("Start"), "days") - dateBetween(prop("End"), prop("Start"), "weeks") * 2 - 1)
dateBetween(prop("End"), empty(prop("Start")) ? dateSubtract(now(), 1, "days") : prop("Start"), "days") - dateBetween(prop("End"), empty(prop("Start")) ? dateSubtract(now(), 1, "days") : prop("Start"), "weeks") * 2 + ((dateBetween(prop("End"), empty(prop("Start")) ? dateSubtract(now(), 1, "days") : prop("Start"), "days") >= 0) ? 0 : (empty(prop("Start")) ? (-2) : 0))

Incl. end date - automatic now

dateBetween(prop("End"), empty(prop("Start")) ? dateSubtract(now(), 1, "days") : prop("Start"), "days") - dateBetween(prop("End"), empty(prop("Start")) ? dateSubtract(now(), 1, "days") : prop("Start"), "weeks") * 2 + ((dateBetween(prop("End"), empty(prop("Start")) ? dateSubtract(now(), 1, "days") : prop("Start"), "days") >= 0) ? 1 : (empty(prop("Start")) ? (-3) : (-1)))