Today plus two business days

[cmdaglish]

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

[Emil_Kos · Accepted solution]

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-f...

[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!