🏞️

Add Business Days

Master Tag

Tips & Tricks

Created

Aug 12, 2020 01:25 AM

How It Works

https://www.redgregory.com/notion/2020/8/21/how-to-add-business-days-in-notion

Usage

Contains

Or

Less Than

Less Than Or Equal To

Web Tags

Database

Planning

Formula

Alternatives

Cover

Video Tour

Video preview

Add Business Days

Name

Date

Date Add *4 Working Days

Date Add *5 Working Days

Aug 16, 2020

Aug 17, 2020

Aug 18, 2020

Aug 19, 2020

Aug 20, 2020

Aug 21, 2020

Aug 22, 2020

Date Add *4 Working Days

long form:

if(day(prop("Date")) == 0, dateAdd(prop("Date"), 4, "days"), if(day(prop("Date")) == 1, dateAdd(prop("Date"), 4, "days"), if(day(prop("Date")) == 2, dateAdd(prop("Date"), 6, "days"), if(day(prop("Date")) == 3, dateAdd(prop("Date"), 6, "days"), if(day(prop("Date")) == 4, dateAdd(prop("Date"), 6, "days"), if(day(prop("Date")) == 5, dateAdd(prop("Date"), 6, "days"), if(day(prop("Date")) == 6, dateAdd(prop("Date"), 5, "days"), now())))))))

Nested form:

if(or(day(prop("Date")) == 0, day(prop("Date")) == 1), dateAdd(prop("Date"), 4, "days"), if(or(or(or(day(prop("Date")) == 2, day(prop("Date")) == 3), day(prop("Date")) == 4), day(prop("Date")) == 5), dateAdd(prop("Date"), 6, "days"), dateAdd(prop("Date"), 5, "days")))

Matrix form:

if(contains("[0 1]", format(day(prop("Date")))), dateAdd(prop("Date"), 4, "days"), if(contains("[2 3 4 5]", format(day(prop("Date")))), dateAdd(prop("Date"), 6, "days"), dateAdd(prop("Date"), 5, "days")))

Short Form:

if(day(prop("Date")) <= 1, dateAdd(prop("Date"), 4, "days"), if(day(prop("Date")) <= 5, dateAdd(prop("Date"), 6, "days"), dateAdd(prop("Date"), 5, "days")))