Home

Gantt Chart

%3CLINGO-SUB%20id%3D%22lingo-sub-897351%22%20slang%3D%22en-US%22%3EGantt%20Chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-897351%22%20slang%3D%22en-US%22%3E%3CP%3EOn%20Agile%20Gantt%20how%20do%20I%20shut%20Saturday%20and%20Sunday%20off%20as%20non-wo%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-897351%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-902507%22%20slang%3D%22en-US%22%3ERE%3A%20Gantt%20Chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-902507%22%20slang%3D%22en-US%22%3EPlease%20post%20your%20file%3C%2FLINGO-BODY%3E
Highlighted
FGariepy471
Visitor

On Agile Gantt how do I shut Saturday and Sunday off as non-wo

2 Replies
Highlighted
Please post your file
Highlighted

@FGariepy471 

Gantt chart usually works with calendar dates. If you prefer workdays only and interpret number of days in column G (if you din't change the template layout) as number of workdays, when in all formulas within calendar grid like

=IF(AND($C10="Goal",I$5>=$F10,I$5<=$F10+$G10-1),2,IF(AND($C10="Milestone",I$5>=$F10,I$5<=$F10+$G10-1),1,""))

you need to change $F10+$G10 (two places) on WORKDAY.INTL($F10,$G10,1).

It's enough in one cell and after that drag it down and to the right.

 

I didn't test, perhaps bit more adjustments will be needed.

Related Conversations
my chart can not smooth the points
inadotb in Excel on
2 Replies