Hi I want to calculate business day
I know how to calculate in excel from networksdays formula i.e NETWORKDAYS(STARTDATE,ENDDATE,Holidays)
But how to calculate in alteryx?
Can anyone help.
I am attaching the sample file as well as holiday file.
Thank you in advance.
Solved! Go to Solution.
Hi @OllieClarke
Thank you for the help.
You have share package file can you please share it in .yxmd format
As I am using older version because of alteryx server.
And one more thing if i want network days in hours how can that be achieved?
@OllieClarke excellent solution!! I think multiplying the network days by 24 will get the network hours
Hi @OllieClarke ,
Thank you for the help.
But in excel I am getting different results
How is this possible?
Attaching file for reference.
No issue I got this simply multiplying network days by 8.
Thank you
Hi @sgaryali
In the above workflow weekends are excluded and not counted. Do you want to do -8 even if Saturday is not considered?
'