Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Find the Number of working Days between 2 dates ( Excluding Weekends and Holidays)

DataPirate26
10 - Fireball

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

2 REPLIES 2
gaoa
11 - Bolide

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

Hi @DataPirate26 

 

Can be achieved with the help of Generate Rows tool.

 

The holiday list is not attached, can you please share.

Labels