Hello all, hoping you can help with this query.
I have a project plan which has 30 odd tasks, for each task the user only needs to enter task, responsible, start date and duration (as in working days).
Some tasks are 2 days, some are 10, 25, one is even 40. My isse is calcuating the completion date based on the start date plus the duration.
For example, if task 1 starts on a Monday and takes 5 days, it's completed on the Friday...easy.
But if task 2 starts on a MOnday and lasts 8 days, it should end the following Wednesday, i.e. 8 working days later. But simply adding the 8 days to the start date would have the task ending on the following Monday as it includes the weekend days.
I've tried various ways including networkdays or if the end date is a saturday then add 2 days etc. nothing seems to work for all durations.
Any help would be great, thanks!
I have a project plan which has 30 odd tasks, for each task the user only needs to enter task, responsible, start date and duration (as in working days).
Some tasks are 2 days, some are 10, 25, one is even 40. My isse is calcuating the completion date based on the start date plus the duration.
For example, if task 1 starts on a Monday and takes 5 days, it's completed on the Friday...easy.
But if task 2 starts on a MOnday and lasts 8 days, it should end the following Wednesday, i.e. 8 working days later. But simply adding the 8 days to the start date would have the task ending on the following Monday as it includes the weekend days.
I've tried various ways including networkdays or if the end date is a saturday then add 2 days etc. nothing seems to work for all durations.
Any help would be great, thanks!