In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

Replicate Excel Networkdays in Alteryx

wonka1234
10 - Fireball
‎05-10-2023 08:01 AM

Hi,

 

I have two date columns, how can I replicate Networkdays formula in alteryx?

 

wonka1234_0-1683730838902.png

 

 

The desired output is 25. However these fields are Date datatypes in alteryx.

Labels:
Reply
0 Likes
2 REPLIES 2
FinnCharlton
13 - Pulsar
‎05-10-2023 08:05 AM

@wonka1234

This is a FAQ, have a look at some of the other past threads on this. This one is a good start: https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Discussions/Networkdays-in-Alteryx/m-p/709...

Reply
0 Likes
wonka1234
10 - Fireball
‎05-10-2023 08:16 AM

@FinnCharlton 

 

thanks, running my example in attached workflow.

NetWorkday.yxmd
Reply
0 Likes
Fall Release Webinar
Alteryx One Admin Experience
Labels
Top Solution Authors
View All