Counting Business Days, disregarding holidays

[ZoeM]

Hello Champs.

I have a need to calculate the number of business days between Start and End disregarding any holidays. And if there is no End date available, calculate # of business days to today.

Below is a sample of data with the requirement.

 Thanks!

[BS_THE_ANALYST]

@ZoeM plenty of solutions to consider here: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Counting-Business-Days-Only/td... 

All the best,

BS

[Qiu]

@ZoeM 
It will be good you can provide the input as data file and also we need a list of Holidays to exclude.

[caltang]

Always good to maintain a separate excel sheet of all the holidays to exclude. Easier to update and change etc.

[ZoeM]

@Qiu I actually have no need to exclude any holidays since we are looping them in.

I have also attached a data sample size. 

[ZoeM]

@BS_THE_ANALYST 

I was actually hoping for something simple beacuse I d onot need to worry about holidays, really just how to exclude Saturday and Sunday from my data set.

[BS_THE_ANALYST]

@ZoeM 
I've attached a file and commented on the tools to provide a structure for you to navigate through. 

That'll show you a way to exclude the weekends between two dates.

All the best,

BS

[BS_THE_ANALYST]

@ZoeM you might want to adjust the count though as I've said if today is the start date and tomorrow is the end date that this is a count of 2 days i.e. Monday & Tuesday. You may want to adjust this and subtract one using a formula tool.

All the best,

BS

[Qiu · Accepted solution]

@ZoeM 
There is very good solution in below thread to your question.

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Count-workday-difference-betwe...
I used the formula there and get it working.

[ZoeM]

While all the solutions provided an answer, this one specifically addressed my exact business need. 

thank you @Qiu