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

Anjankumar2021

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

Date	Output
01/01/2025	17/01/2025
03/03/2025	19/01/2025

Workflow

Accepted answers

binu_acs

@Anjankumar2021 try the attached workflow

Date_20032025.yxmd

All comments

binu_acs

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

Anjankumar2021

Date	No of days	after adding	Holiday list	Output
01/01/2025	15	16/01/2025	15/01/2025	17/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

binu_acs

@Anjankumar2021 try the attached workflow

Date_20032025.yxmd

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703