Find end date for a 3 days per week workday

Sakantamany

Hello,

need help to find end date, the bellow data is available:

1) Start date

2) Number of days to finish the task

3) Non working days are (Monday, Wednesday, Friday, Saturday).

Thank you in advance.

Sakantamany

Yayy !

i found the solution as below:

https://www.youtube.com/watch?v=Wyoo9mQPxCY

simply use networkdays.intl(startdate,days, "01010101")

what is the meaning of "01010101"; it means that starting from Monday i can select my working days as 0 and non working days that i want not to count as 1. :D

so i can count as many or as low as i want.

Sakantamany

i can do this for 5 working days per week but not 3 working days per week.

if 5 working days, i use (workday.intl) formula.

I even tried to use the holiday to select Monday and Wednesday but in this formula it requires exact dates.

Therefore, I cannot do it, If holiday could let me select 12 and 14 which are equivalent to Monday and Wednesday, my problem would have been solved.

so help please

Sakantamany

Yayy !

i found the solution as below:

https://www.youtube.com/watch?v=Wyoo9mQPxCY

simply use networkdays.intl(startdate,days, "01010101")

what is the meaning of "01010101"; it means that starting from Monday i can select my working days as 0 and non working days that i want not to count as 1. :D

so i can count as many or as low as i want.