In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Make sure to check your account preferences in my.alteryx.com to make sure you have filled out your security questions. Learn more 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.
SOLVED

How to add 15 days to a date and need to exclude weekends and holidays in the ouput

Anjankumar2021
8 - Asteroid
‎03-20-2025 12:53 AM

Hi Team / @binu_acs ,

 

could someone assist on the below?

 

Input:

 

Date
01/01/2025
03/03/2025

 

Holiday list
15/01/2025
10/03/2025
10/10/2025

 

OUtput:

 

excluded weekends and holidays after adding 15 days to date and take next possible weekday

 

DateOutput
01/01/202517/01/2025
03/03/202519/01/2025
Labels:
Reply
0 Likes

Accepted SolutionSolved! Go to Solution.

3 REPLIES 3
binu_acs
21 - Polaris
‎03-20-2025 01:13 AM

@Anjankumar2021 would you mind explaining the calculation of the output 17/01/2025

Reply
0 Likes
Anjankumar2021
8 - Asteroid
‎03-20-2025 01:27 AM

 

DateNo of daysafter adding Holiday listOutput
01/01/20251516/01/202515/01/202517/01/2025

 

after adding 15days the date should be 16/01/2025 but 15/01/2025 was holiday and no weekend came( Saturday and Sunday). excluded holiday and  took next possible business day 17/01/2025

Reply
0 Likes
binu_acs
21 - Polaris
‎03-20-2025 02:51 AM

@Anjankumar2021 try the attached workflow

image.png

Date_20032025.yxmd
Reply
Labels
Top Solution Authors
View All