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.
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-in-Alteryx/td-p/556676
Hope that helps,
Angelos
