Network days calculation between 2 fields

[Inactive User]

Hello,

Need a formula which calculates the networkday between 2 days and provides an output. 
For example - the original date is 02/26/2021 and today's date is 03/08/2021 - the result should display - 07.

awaiting quicker response from the experts !   

Thanks,

Guru 

[Emil_Kos]

Hi @Inactive User,

Alteryx don't have holidays build in. I think you would need to create your own list of holidays to calculate them.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Networkdays-in-Alteryx/m-p/70989/highlight/true#M24981

Check this post and the workflow attached to it for a great overview of how this can be achieved in Alteryx. 

At the same time, I just think this workflow should work for you. One small change is updating the holiday times. 

[Emil_Kos]

Hi @Inactive User,

If you are not interested in the holidays list but you just want to calculate working days you can also check this solution:

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Calculate-Business-Days-Between-Dates/ta-p/31000

[Inactive User]

Hello @Emil_Kos 

I tried to apply this logic - it didn't produced the correct output.
As i stated earlier - i need to find a networkday difference between 2 days and should show as numbers.
Example - 02/26/2021 minus 03/08/2021 is 07 - excluding Sunday and Saturday as weekly off. 
If possible provide me the formula that calculates 2 values. thanks !  

[Emil_Kos · Accepted solution]

Hi @Inactive User,

I checked your numbers and the difference is 7.

The output:

[Inactive User]

Thanks !  @Emil_Kos it worked