Add calendar days to a date, but the final date must be a labor day

[hcova]

Dear friends:
I have a "base date" and I need to add calendar numbers of days to get a "final date".
The only condition I need is the "final date" must be the next labor day.
For example if I add 22 calendar days to today friday 05.21.2021 I will get the saturday 06.12.2021.
In this example I would like to get the next labor day. I mean, the monday 06.14.2021
(If this monday is holiday, I would like to get tuesday 06.15.2021)

Is there any excel function to do this, or I need to write a complex formula or a vba code?

Regards
HC

 

[Fluff]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

You can use the WORKDAY.INTL function for that. How to use the Excel WORKDAY.INTL function | Exceljet

 

[hcova]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

You can use the WORKDAY.INTL function for that. How to use the Excel WORKDAY.INTL function | Exceljet

Hi there but WORKDAY.INTL doesn't work because it lets you customize which days of the week are considered weekends during all the period of days.
However with this formula you can not set special conditions at the "final date".
Again, if you add 22 calendar days to 05.21.2021 I will get the saturday 06.12.2021.
I need to add these 22 calendar days and get the next labor day: monday 06.14.2021
Best regards
Hernan

 

[hcova]

Hi there but WORKDAY.INTL doesn't work because it lets you customize which days of the week are considered weekends during all the period of days.
However with this formula you can not set special conditions at the "final date".
Again, if you add 22 calendar days to 05.21.2021 I will get the saturday 06.12.2021.
I need to add these 22 calendar days and get the next labor day: monday 06.14.2021
Best regards
Hernan

I found the solution:
=WORKDAY(Base date+Calendar Days-1;1) you will always get a labor date as Final Date. You can improve it including holiday days!
Regards
Hernan

 

[hcova]

Anyway, credits are for Barry Houdini, MrExcel MVP