Alteryx Designer Desktop Discussions

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

Days Difference between 2 dates excluding Weekends (Sat & Sun)

itsmeanuj
7 - Meteor

Hi,

 

I have a huge dataset where I want to calculate the difference between 2 dates including only Business days (i.e. I just need to exclude weekends). Below is the sample data with the expected output. Data is in the DD-MM-YYYY Format.

 

First DateShipment DateDifference (Expected Output
10-06-202012-06-20202
03-08-202007-08-20204
28-08-202028-08-20200
07-10-202113-10-20214
09-07-202009-07-20200
09-07-202016-07-20205
10 REPLIES 10
Felipe_Ribeir0
16 - Nebula

Hi @itsmeanuj 

 

One option that does not need to generate rows. Just formulas:

 

Felipe_Ribeir0_0-1672444603880.png

 

Labels