Find end date for a 3 days per week workday

Options

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

Answers

  • Sakantamany
    Sakantamany ✭✭
    edited 07/25/22
    Options

    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
    Sakantamany ✭✭
    Answer ✓
    Options

    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

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!