Alteryx Designer Desktop Discussions

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

Easiest way to do datetimediff no weekends

wonka1234
10 - Fireball

Hi,

 

How can I do datetimediff and exclude weekends? I see solutions online that are kind of hard.

I do have a business date generator, not sure if that would help.

 

I am trying to make the workflow as least confusing as possible.

 

Ie 

 
TodayDue Date Formatteddiff
8/15/20238/11/2023-4

 

 

I would expect -2 here instead.. 

 

thanks

10 REPLIES 10
ArnaldoSandoval
12 - Quasar

Thanks @wonka1234 I like my formula better although there are always rounding considerations

 

Arnaldo

Labels