<aside> ℹ️ Code can be found below the table. Alternatively, you can duplicate this page in the top right corner.

</aside>

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

</aside>

<aside> ✅ Validated using: https://www.timeanddate.com/date/workdays.html

Does not work with holidays!

</aside>

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)))