Today plus two business days

Hi All,

I was wondering if someone could help me figure out how to add two business days to today's date.

I have figured out the formula on how to add two business days...

IF DateTimeFormat(DateTimeAdd([Date],2,"days"),"%a") = "Sat" or DateTimeFormat(DateTimeAdd([Date],2,"days"),"%a") = "Sun" THEN DateTimeAdd([Date],4,"days") ELSE DateTimeAdd([Date],2,"days") ENDIF

... but I am struggling with incorporating bank holidays into my flow.

I have another input tool which will bring in all future bank holidays.

Any help would be appreciated.

Many thanks

Tips and Tricks

Date Time

Help

Join

Accepted answers

Emil_Kos

Hi,

I have a solution from this post to create a workflow for you. @danilang created amazing workflow

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-add-business-days-to-the-date-field/m-p/414856/highlight/true#M76584

BusinessDays 2.yxmd

All comments

Emil_Kos

Hi,

I have a solution from this post to create a workflow for you. @danilang created amazing workflow

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/How-to-add-business-days-to-the-date-field/m-p/414856/highlight/true#M76584

BusinessDays 2.yxmd

Qiu

@Emil_Kos
Nice one.

I am think to use Macro even.😁

cmdaglish

I had to amend the last filter to be [DayCount] = [BusinessDays]+1 for what I needed but apart from that it works perfectly.

Thanks a lot!

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703