Forum Discussion
tamara390
Nov 28, 2021Copper Contributor
Agile Gantt chart - removing weekend - PLEASE HELP!
I am trying to remove weekend from my agile gantt chart. I am using the excel template. I have searched the internet for about 2 hours and i cannot find a solution. Please help I am on a deadline.
6 Replies
Sort By
I guess you may use WORKDAY() function. Here
In formula here
as
=IF(AND( $C14="Goal", I$7>=$F14, I$7 <= WORKDAY($F14, $G14)-1 ),2, IF(AND($C14="Milestone",I$7>=$F14, I$7 <= WORKDAY($F14, $G14) -1 ),1,""))
and in conditional formatting rule formula
- CTysonCopper Contributor
Thanks a million. The formulas worked!!SergeiBaklan
CTyson , glad to help
- hlokeyCopper Contributor
This is helpful (thanks for including the template) but I'd lactually like to see the weekends in the calendar but to have them not be colored for the task. So if a low-risk task lasts 10 days there would be 10 blue workdays and then the weekends that fall in the middle would either be white or some subtle color like grey to show that they are excluded from the task.
Also, would it be possible to have a column (maybe add right after G "days") where you can decide if the task will exclude weekends and then the conditioning will be based off of that?
Thank you!