Find the Number of working Days between 2 dates ( Excluding Weekends and Holidays)
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
DataPirate26
10 - Fireball
‎03-02-2023
09:43 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi all,
I have attached a sample workflow below. I need to find out the number of working days between 2 dates ( Excluding the Saturday Sundays and the Dates which are there in the Holiday List file [(Need to exclude the holidays as well)]
Field 1 : Last of Month HD
Field 2: Start Date
Can someone help me out in this. Let me know if any confusion is there
Labels:
- Labels:
- Dynamic Processing
2 REPLIES 2
gaoa
11 - Bolide
‎03-02-2023
10:10 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Hi @DataPirate26 Have you checked out this weekly challenge? Challenge #248: Holidates - Alteryx Community It is trying to solve a similar question. Hope it helps!
ShankerV
17 - Castor
‎03-02-2023
10:13 PM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
Can be achieved with the help of Generate Rows tool.
The holiday list is not attached, can you please share.
