Formula using two different excel sheets

[jrook20]

Hi all,

I am looking to create a formula that uses two excel sheets. The excel formula is:

=MAX(NETWORKDAYS(J2,P2,Holidays!$A$2:$A$32),0)-1

Thanks

[OTrieger]

@jrook20 
The excel formula is as follow:
MAX - get max value
NETWORKDAYS(Start_date, End_Date, holidays)
So from one sheet you are getting the dates and from the second one your are getting the holidays.

In Alteryx your have DateTimeDiff(dt1,dt2,u) 
u is days in your case.

So in your case you will need DateTimeDiff(dt1,dt2,"days")-holidays and also -1

[jrook20]

Thank you for the response but I still have some questions as I am a bit novice. Do I want to union the two sheets and then have the formula DateTimeDiff([Name of Column J], [Name of Column P], "days")-[Holiday Column]-1?

[KGT]

The breakdown above helps to visualise the problem. Network Days formulas get a pretty quick response on here rather than a build-out, as it's so common. There are several macros floating around on the community and a lot of questions with answers.

• Link: Search string
• Macro: https://community.alteryx.com/t5/Community-Gallery/Network-Days/ta-p/1056599
• https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Network-Day-s-Formula/td-p/892...
• https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Networkdays-in-Alteryx/m-p/709...

[Vinayakk88]

First of all,  its not that quick and simple to do in Alteryx.

Step 1: 
use existing solution posted to similar question few years back (you can use any other file/sheet which you want to join as Holiday table

->  then get your NETWORKDAYS

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Excel-Function-Workday-and-Net... 

Step 2:

Then you use Formula tool on that,  to write MAX Function

Step 3: 

"-1"