Datetimediff using only weekdays/business days

[JessicaAddy]

Is there a way to calculate the number of weekdays/business days between two dates?  I have spent some time searching the internet and the Alteryx Community, but cannot find any solutions to this.

Thanks!

Jessica

[ponraj]

Here is the sample workflow for your case. Hope this is helpful. 

WorkflowResults

[maramtx25]

Hi jdunkerley79, 

Would you please explain this part:

1 + 
 ((DateTimeDiff([EndDate],[StartDate],"days")*5 - ([StartWeekday]-[EndWeekday])*2) / 7) +
 IIF([EndWeekday]==6,-1,0) +
 IIF([StartWeekday]==0,-1,0)

Regards,

MJ 

[CRogers22]

I've been using jdunkerley79's solution and its working great until I ran into negative numbers. It just pulls Null if negative and I need the actual result (the negative number).  Does anyone know a fix for this?