Find end date for a 3 days per week workday
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.
Best Answer

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.
Answers

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

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.
Help Article Resources
Categories
Check out the Formula Handbook template!