Forum Discussion
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
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
Thanks a million. The formulas worked!!SergeiBaklan
CTyson , glad to help
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!
