Calculation of Networkday

[rohitashsharma]

Hi Team, 

I have always been struggling, though we have an option to calculate it by adding rows, yet it is a bit longer than how it should have been, and I hope most of the users must also be facing this challenge, thus wish to request the development team to create something under formula to make this task easier, instead of using a long way the formula can help better.

Not sure if it can be perform through formula, if yes please let me know with an example.

Thanks.

[ChrisTX]

Can you provide sample input and desired output?  And please re-phrase your question to describe the request.  The initial post doesn't provide information to help you.

Chris

[binuacs]

@rohitashsharma The below post might give you some idea about how to calculate the network days in Alteryx

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Networkdays-in-Alteryx/td-p/70976

[ShankerV]

Hi @rohitashsharma 

Do you want to exclude the weekends, Saturday and Sunday during your calculation.

Also share the input how it is and the desired output also please.

Edit: If you want to explore more the below link will give you what you need.

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Excel-function-Networkdays-substitute-...