<aside> ⚠️ Includes end date in the calculation and does not exclude public holidays.
</aside>
(prop("Start") < prop("End")) ? (ceil(dateBetween(prop("End"), prop("Start"), "hours") / 24) - floor(ceil(dateBetween(prop("End"), prop("Start"), "hours") / 24) / 7) * 2 + ((toNumber(formatDate(prop("Start"), "d")) - toNumber(formatDate(prop("End"), "d")) >= 1) ? (-2) : 0) + (and(toNumber(formatDate(prop("Start"), "d")) == 0, toNumber(formatDate(prop("End"), "d")) != 6) ? (-1) : 0) + (and(toNumber(formatDate(prop("End"), "d")) == 6, toNumber(formatDate(prop("Start"), "d")) != 0) ? (-1) : 0) + ((toNumber(formatDate(prop("Start"), "d")) - toNumber(formatDate(prop("End"), "d")) == -6) ? (-2) : 0) + 1) : toNumber("")
<aside> <img src="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/1649d2f9-1b45-478a-86b4-341fbe27e06f/benny.png" alt="https://s3-us-west-2.amazonaws.com/secure.notion-static.com/1649d2f9-1b45-478a-86b4-341fbe27e06f/benny.png" width="40px" /> By Ben • Latest • Was this helpful? Please consider buying me a coffee. Cheers!
</aside>
