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.

[sgaryali]

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.

[atcodedog05 · Accepted solution]

Hi @sgaryali 

Check whether this works for you.

Workflow:

Hope this helps : )

[atcodedog05]

Happy to help : ) @sgaryali 

Cheers and have a nice day!

[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