Challenge #248: Holidates

[gawa]

Done

[jdbaldwin]

My solution is a little more general, though not fully generalized. And I just did a browse tool without bothering to put it in an Excel output file.

Still, I think it's worth looking at.

Spoiler

[mertshepard]

Solution attached.

[alacoume]

My solution:

[jpg34]

My solution

Spoiler

 

[MDestra]

Challenge #248:

[BenoitC]

Done!

Spoiler

[Sanricson]

Hi all, I am new to Alteryx. Thank you for all the solutions, this is very useful. However, the dates seems to be prefix for year 2021. My current assignment is to calculate the number of business dates (exclude holidays and weekends) between any 2 given dates from an excel file. However, there will be scenario where 1 or both of the dates may be null in the excel. If this happen, it is not require to calculate the business days. Appreciate your help as my assisgnment is end of this week. Thank you

[networkmike42]

Spoiler

 

[emily_cummings]

Solution: