Exclude Weekends and Holidays between Date Range

[Dhilip_Kumar]

Hi All,

I have attached my input file, it contains Name Date of Hire and Current date, I want to calculate number of days between hire date and Current date excluding Saturday, Sunday and Holiday list which is in another tab on the same file.

Please do the needful to me.

[alexnajm]

There are examples of this being solved on the Community: Solved: How to exclude Weekends & Some fixed list of holid... - Alteryx Community. Please try it first and ask us any questions that you have!

[MelGibson]

not sure this is the easiest way but it was the fastest for me. Hope it helps

[JosephSerpis]

Hi @Dhilip_Kumar there a Alteryx weekly challenge which tackles this you can see others have tackled this challenge