Subtracting Holidays from Business Days

So I have the business days calculating correctly. Is there anyway to have alteryx look at a list of dates, see if these dates are in the range (Start Date and End Date) and return a 1 if it is and a 0 if it is not?

Example:

Start Date is 2/27/2017

End Date is 3/2/2017

Holiday is 3/1/2017.

Date Time

Accepted answers

Philip

There may be a more elegant way, but here is one using Find/Replace Tool. I'd prefer this over Join to avoid duplicating records. Instead, it looks to see if the date is contained in the Holiday list. Note that the orange section is just creating dates to use in the example.

Mark holidays.png

Mark holidays.yxmd

All comments

alex

Can you supply a file as an example. Not sure exactly what you need from your description.

MadeInHB

So right now I have business days calculating. For the example 2/27 - 3/2, it is calculating 3 days. But let's say 3/1 is Holiday. I am looking for a way to have Alteryx see 3/1 as a Holiday and return a 1. Then I can set the formula to do 3-1, to return that it is actually 2 business days and not 3. But I am stuck with the variable holiday dates.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15875

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703