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