Calculating the Total Number of Week Days Between Two Dates in Notion

Notion is creeping into my life more and more, and one helpful little database I made is to track my PTO and the number of days I’ve taken or plan to take. I know the company tracks this, but checking Notion is much faster for me.

Here’s the formula to use to calculate the number of days off. It accounts for weekends and week days. I got it from this reddit post .

dateBetween(end(prop("Dates")), start(prop("Dates")), "days") + 1 - (dateBetween(end(prop("Dates")), start(prop("Dates")), "weeks") * 2 + min(max(day(prop("Dates")) + dateBetween(end(prop("Dates")), start(prop("Dates")), "days") % 7 - 5, 0), 2))

Work Log

An email newsletter documenting the work of Sofa's creator, Shawn Hickman.

    No spam. Unsubscribe at any time.

    Start Organizing
    Your Downtime

    All you have to do is press that button.