how to convert network formula and MOD formula to alteryx

[VeronicaElse]

Hello,

I am super new to Alteryx and I was able to see examples of using a MACRO I think that's what it was for this. I wanted to make sure that is correct for this below formula:

= NETWORKDAYS(D271, AG271) - 1- MOD(D271,1) + MOD(AG271,1)

Thanks!

[AngelosPachis]

Hi @VeronicaElse ,

Is this what you are looking for? Can you try it on a couple of dates from your data and tell me if it works for you please?

Cheers,

Angelos

[SeanAdams]

Hey @VeronicaElse 

NetWorkDays is a common need and @NicoleJohnson did a great write up on this a while ago.

You can find this here: 

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Networkdays-in-Alteryx/td-p/70976