In case you missed the announcement: Alteryx One is here, and so is the Spring Release! Learn more about these new and exciting releases here!

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
Top Solution Authors