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)
Thank you HansVogelaar and Kidd_Ip I'm attaching a sample with the recommended changes. L5 is the cell I've been changing.
LMK if you can't access this. https://docs.google.com/spreadsheets/d/1t1P8IBDLoXrytMGfEA3N1Ko_MrdoWoNC/edit?usp=drive_link&ouid=109580642755491160878&rtpof=true&sd=true
I get "Access Denied"
HansVogelaarsorry about that, I updated the settings so this should work now. https://docs.google.com/spreadsheets/d/1t1P8IBDLoXrytMGfEA3N1Ko_MrdoWoNC/edit?usp=sharing&rtpof=true&sd=true
See the attached version. I changed the formulas in M5 and to the right, and I changed row 4 to display 5-day weeks.