Let’s talk Alteryx Copilot. Join the live AMA event to connect with the Alteryx team, ask questions, and hear how others are exploring what Copilot can do. Have Copilot questions? Ask 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

Community Gallery

Create, download, and share user-built tools and workflows.
Looking for Alteryx built Add-Ons?

Easily shop verified, supported, and secure Partner and Alteryx built Add-Ons on Marketplace.

LEARN MORE
Networking day
Macros Uploaded by on 02-17-2025 Downloaded 19 times
  • Automation
  • Macros
  • Prep and Blend
    • Download
    0 Likes
    Post Comment

    Description

    use formula to calculate the networking day. 

     

    benefit is faster compared to generate rows method. especially the date range is high (>10000)


    proof: 10k line with random range of 10000 day. 
    time used: 92.11 ms vs 82,134.52 ms

     

    Limitation:

    - Only cover Mon-Fri

    - you may use holiday generator as this is not cover.

     

    Update 6 May 2025:

    update formula to cover [end date] > [start date]

    Screenshot 2025-02-18 114729.png

     

    Attachments
    net working day.yxmc