Finding Nth Business Day

Question

Hi Community!

Is it possible to find Nth business day in the workflow?

For example, before begin processing any data in the workflow, I want to check if today is 4th business day, if it is then proceed.

I know with Excel, I can use the formula =WORKDAY(DATE(A2,B2,0),4) but I don't know to use this in Alteryx.

Thank you!

rockeylearning · Answer

Although I haven't tried this yet, but in searching the Community, I found various options that I may able to combining to get the end  desire's:

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Calculate-Business-Days-in-Month-Removing-Holidays/td-p/443715

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Counting-Business-Days-Only/td-p/114793

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/How-to-find-last-month-last-business-day/td-p/147220