Exclude Weekends and Holidays between Date Range

Question

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.

Dummy Data.xlsx

JosephSerpis · Answer

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

MelGibson · Answer

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

NETWORK DAY LESS HOLIDAY.yxmd

alexnajm · Answer

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!