Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask here!
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Formula using two different excel sheets

jrook20
6 - Meteoroid

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

4 REPLIES 4
OTrieger
14 - Magnetar

@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
6 - Meteoroid

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
13 - Pulsar

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.

 

 

 

Vinayakk88
6 - Meteoroid

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"

Labels
Top Solution Authors