Network Day's Formula

[sgaryali]

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.

[OllieClarke]

Hey @sgaryali 

Here's how I would do this:

Hope that helps,

Ollie

[sgaryali]

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 · Accepted solution]

Hi @sgaryali here's how you can do hours as well:

I've attached the .yxmd

Hope that helps,

Ollie

[binuacs]

@OllieClarke excellent solution!! I think multiplying the network days by 24  will get the network hours

[OllieClarke]

@binuacs lol, that's a much better solution

[sgaryali]

Hi @OllieClarke ,

Thank you for the help.

But in excel I am getting different results

How is this possible?

Attaching file for reference.

[sgaryali]

No issue I got this simply multiplying network days  by 8.
Thank you

[sgaryali]

Hi

I want one more logic to be added.
If holiday falls on Saturday then then nominal hours i.e.(network days*8) should be reduced by 8.

Can we do that?

[atcodedog05]

Hi @sgaryali 

In the above workflow weekends are excluded and not counted. Do you want to do -8 even if Saturday is not considered?

'