Donate
Ever wonder how to add business days in Notion? This formulas ensures every date you push forward lands on a weekday between Monday and Friday. This is possible using the day() function. In short, if date lands on a Saturday, push an additional two days, and one day for Sunday.
if(day(dateAdd(prop("Start"), toNumber(prop("Push")), "days")) == 6, dateAdd(dateAdd(prop("Start"), toNumber(prop("Push")), "days"), 2, "days"), if(day(dateAdd(prop("Start"), toNumber(prop("Push")), "days")) == 0, dateAdd(dateAdd(prop("Start"), toNumber(prop("Push")), "days"), 1, "days"), dateAdd(prop("Start"), toNumber(prop("Push")), "days")))