Networkdays

[Kinetic_analytics]

I am confused to calculate network days.  I only consider Saturday and Sunday as weekends.  The report is as per yesterday's closing. in Excel I use =Today()-1

appreciate your solutions.

[AngelosPachis]

Hi @Kinetic_analytics 

You can find an answer to your question in the following post by @NicoleJohnson and other posts that can help you by @KaneG .

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

Since you don't care about holidays, you don't need to use a Join tool, so you can skip that.

There's also a macro that you can download from the gallery, according to this post by @AshleyL :

https://community.alteryx.com/t5/Alteryx-Designer-Discussions/Excel-function-Networkdays-substitute-...

Hope that helps,

Angelos