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

Question

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

Test Workflow.yxmd

ShankerV · Answer

Hi @DataPirate26

Can be achieved with the help of Generate Rows tool.

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

gaoa · Answer

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!