Calculate by Adding 2 Days from Date

[KamenRider]

Hi Guys,

Would someone help me how to get the date by 2 days but will not count weekends (Saturday and Sunday) as well as US holidays?

For example my date is September 1, 2023 (Friday)

Sept 2 and 3 are weekends so it will not be included in the count

Sept 4 is US Labor Day

So if I am going to add to days, the date should be September 6, 2023.

Please help me derive the formula.

Thanks and hope to hear from someone.

Kamen

[rzdodson]

In this use case, it basically is pulling down data from an external source and then breaking categories up similar to how a Transposed data set looks in Alteryx.

Since you're running into an issue opening up external links, I'll get the workflow converted for you and repost.

[rzdodson · Accepted solution]

@KamenRider I have adjusted the solution from above and am reposting the file for you here. 

I removed these tools for you (see below). 

I also went ahead and loaded 10 years worth of US holidays in the attached solution for you since you cannot access external links. Let me know if it does not work out for you.

Here is what the workflow looks like (for now).

[KamenRider]

Hi @rzdodson 

This looks good. Thanks.

Kamen