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

Great! You’ve successfully signed up.

Welcome back! You've successfully signed in.

You've successfully subscribed to Shawn Hickman.

Success! Check your email for magic link to sign-in.

Success! Your billing info has been updated.

Your billing was not updated.