Network Day's Formula

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.

Sample File.xlsx

Workflow

Accepted answers

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

I've attached the .yxmd

Hope that helps,

Ollie

Check whether this works for you.

Workflow:

Hope this helps : )

Sample File (1).xlsx

All comments

Here's how I would do this:

Hope that helps,

Ollie

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?

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

I've attached the .yxmd

Hope that helps,

Ollie

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

@binu_acs lol, that's a much better solution

Hi @OllieClarke ,

Thank you for the help.

But in excel I am getting different results

How is this possible?

Attaching file for reference.

Sample File.xlsx

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

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?

Sample File.xlsx

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

'

Hi @atcodedog05

Yes I want to do -8 even if Saturday is not considered only if I have holiday on Saturday in the holiday file.

Check whether this works for you.

Workflow:

Hope this helps : )

Sample File (1).xlsx

sajithanandcheriyil

I think with simple formula tool we can resolve it,

1 + ((DateTimeDiff(End,Start,"days")*5 - (ToNumber(DateTimeFormat(Start, "%w"))-ToNumber(DateTimeFormat(End, "%w")))*2) / 7) + IIF(DateTimeFormat(End, "%w")=="6",-1,0) +
IIF(DateTimeFormat(Start, "%w")=="0",-1,0)

END- End Date

START - Start Date

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15875

MarqueeCrew 13708

apathetichell 13703