<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>
dateBetween(prop("End"), prop("Start"), "days") - dateBetween(prop("End"), prop("Start"), "weeks") * 2
(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))
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)))