How To Add 17 Business Days from a given date

[Abhi15 (Abhi)]

Hi

Please help me to find out how to get 17 business days for a given date excluding sat and sun.

[THIRU_NANI (NaNi)]

Hi!

Have a view on this thread…

How to add 5 business days to the date

I would like to add 5 business days to a certain date. which means i have to be aware of sat and sun is this possible in uipath?

How to calculate number of weekdays without SAT/SUN between two dates

Hello all, How to calculate total number of WEEKDAYS between two dates? Custome activity I used is giving me incorrect result. I want to exclude Saturday and Sunday.

Component:

Working Days Calculation - RPA Component | UiPath Marketplace | Overview

Regards,
NaNi

[Gokul001 (Gokul Balaji)]

HI @Abhi15

Check out this custom activity in the MarketPlace

Business Days Calculator - RPA Component | UiPath Marketplace

Calculate Business Days - RPA Component | UiPath Marketplace

[arivu96 (Arivazhagan A)]

@Abhi15

17 business days for a given date excluding sat and sun.

Try below logic in UiPath

while (daysToAdd > 0)
    {
        date = date.AddDays(1);

        if (date.DayOfWeek != DayOfWeek.Saturday && date.DayOfWeek != DayOfWeek.Sunday)
        {
            daysToAdd -= 1;
        }
    }

Regards,
Arivu

[Gangadhar_Athili]