Forum Discussion
Solved
Gantt Chart without weekends
I have a Gantt chart in Excel to help us with project management and timing. I found an example a few weeks ago and have modified it to get about 95% of the way done. The issue is weekends. The char...
In columns H and I, change formulas such as
=I9-D9
to
=WORKDAY(I9, -D9)
Try this:
Asjut the Start Date Calculation:
=WORKDAY(Project_Start, -7*(Display_Week-1))
Adjust Task Dates:
=WORKDAY(Start_Date, Duration-1)
Modify the Chart to Exclude Weekends:
=IF(OR(WEEKDAY(Date, 2)=6, WEEKDAY(Date, 2)=7), "Weekend", "Weekday")