Networkdays
Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
Kinetic_analytics
11 - Bolide
‎12-09-2021
11:00 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
1 REPLY 1
AngelosPachis
16 - Nebula
‎12-09-2021
11:08 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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 :
Hope that helps,
Angelos
![](/skins/images/33644471E927638F516C93A75ADDEE18/responsive_peak/images/icon_anonymous_message.png)