Business days calculation between two dates with a holiday input calendar

Still new to Alteryx and I have a certain issue i am trying to reslove with Business days.

I have a scheduled due date and an actual received date and I am trying to calculate the number of business days between them and input a holiday calendar into the flow to account for the those days. I have seen several different threads on this but I am not getting a clear path forward. If someone could screen shot the flow that could best help me in my situation I would appreciate it.

Accepted answers

BenMoss

Hi!

ive built a custom tool that allows you to do this, including the option to load a holiday file, it can be found here...

https://gallery.alteryx.com/#!app/Working%2BDay%2BTime%2BDifference/5a0ad875f499c708d037257c

Ben

All comments

JosephSerpis

Hi @dcrigger there is a Alteryx weekly challenge that solves this challenge you might want to look at. Here is the link.

dcrigger

I have along list of Data that has scheduled delivery date and accual delivery date and dont need a user selected date this is around 1000 lines

BenMoss

Hi!

ive built a custom tool that allows you to do this, including the option to load a holiday file, it can be found here...

https://gallery.alteryx.com/#!app/Working%2BDay%2BTime%2BDifference/5a0ad875f499c708d037257c

Ben

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15865

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703