Forum Discussion
Gantt Chart without weekends
In columns H and I, change formulas such as
=I9-D9
to
=WORKDAY(I9, -D9)
Thank you HansVogelaar ! This is getting so close now... the one thing, and I don't know if this can be changed, is how to set the dates based on the length of task (time to complete) without including weekends. Our projects (the ones we can plan for LOL) work back from a launch date. I'm trying to set up a base template so that we can add the tasks that need to be completed, how long each task takes and essentially use the calculations to determine the date we need to start the project in order to meet that end launch date.
The base calculation I've been using is just subtracting dates and Days to Complete, which doesn't take weekends out of the equation. Those are the Start and End dates in columns H and I.
I tried adding "WORKDAY" to the calculation but that didn't work. Do you know if it's possible to calculate for workdays and not weekends?
In columns H and I, change formulas such as
=I9-D9
to
=WORKDAY(I9, -D9)
Thank you so much HansVogelaar ! I'm going to build a template for my team, working back from launch dates. Then I also hope to make one for working forward from a start date as well.
You've been an incredible help, and I cannot even begin to express how much I appreciate your assistance!