How to add 5 business day

[c3f1e68294fdcf4a1f0a817ca (Rakesh Gupta)]

Hi Experts,

I need to add 5 business day to input date( That I will pass)

I went through fourms and found this

How to add 5 business days to the date

Hi, The best solution for this would be a especific workflow. In my case i build a “GetNextNWorkDay” build a workflow: 2 in atributtes: 1. DateOrigin 2. Number of days 1 out atribute: 1. DateOut Workflow should be like: dateOut=dateorigin for each Enumerable.Range(0,Math.Abs(Number of days)) do dateOut = dateOut.AddDays(NumberOfDays/Math.Abs(Number of days)) Note: this will work forwards and backwards if only want one direction just place +1 or -1. while ({DayOfWeek.Saturday,DayOfWeek.…

Above I tried and not working.

And for 2 business days found this, below is working but only for 2 days.
How to change it for 5 days and if possible explain concept also.

Now.AddDays({3,2,2,2,4,4,3}(Now.DayOfWeek)).ToString

Any experts please help

[Yoichi]

Hi,

We can create it from actual calendar as the following.

Jun 19(Sun) + 5 business days = Jun 24(Fri) : +5
Jun 20(Mon) + 5 business days = Jun 27(Mon) : +7
Jun 21(Tue) + 5 business days = Jun 28(Tue) : +7
Jun 22(Wed) + 5 business days = Jun 29(Wed) : +7
Jun 23(Thu) + 5 business days = Jun 30(Thu) : +7
Jun 24(Fri) + 5 business days = Jul 1(Fri) : +7
Jun 25(Sat) + 5 business days = Jul 1(Fri) : +6

From the above, the expression would be

Now.AddDays({5,7,7,7,7,7,6}(Cint(Now.DayOfWeek))).ToString()

Regards,