Calculation of Networkday

Question

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.

ShankerV · Answer

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-in-Alteryx/td-p/556676

binu_acs · Answer

@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

ChrisTX · Answer

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