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

[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 · Accepted solution]

@Anjankumar2021 try the attached workflow