Hi All,
One more Gantt Chart question for everyone. I am using the Agile Gantt Chart template and along the way of my customizing, I lost the Saturday and Sundays on the calendar as seen below.
PS30Days1.jpg
Currently I have the following formula in K7:I know I'm using WORKDAYS to calculate working weekdays, but I still want to be able to see Saturdays and Sundays - perhaps grayed out instead of entirely gone like the example snapshot below. I tried using WORKDAY.INTL and ended up wrecking it.![]()
Please Login or Register to view this content.
Then I thought maybe I need to change the calendar itself, so the formula I'm using in J11 is:
Do I need to edit this cell instead to get it to skip Sat/Sun? If so, what changes should it show?![]()
Please Login or Register to view this content.
PS30Days2.jpg
If anyone has any suggestions, it would be most appreciated!
PS30Days.xlsx
Bookmarks