Formula

[VeronicaElse]

Hello,

How do I input this formula from excel to Alteryx?

= NETWORKDAYS(D609, AG609) - 1- MOD(D609,1) + MOD(AG609,1)

Thanks!

[danilang · Accepted solution]

Hi @VeronicaElse 

There's no built in function to return only business days.  You'll have to use something like the workflow here. As for the two MOD functions, MOD(x,1) is always 0 for any number so you can just exclude these completely

Dan