Add Business Days

Add Business Days

Master Tag
Tips & Tricks
Created
Apr 24, 2022 02:35 AM
How It Works
Usage
dateAdd
toNumber
Web Tags
Formula
Database
Alternatives
Cover

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.
 
Add Business Days
Name
Start
Push
Shipped
Apr 22, 2022
1 day
Apr 21, 2022
7 days
Apr 18, 2022
20 days
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")))