Calculate by Adding 2 Days from Date
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
Solved! Go to Solution.
- Labels:
- Common Use Cases
- Date Time
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@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).
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator

- « Previous
-
- 1
- 2
- Next »