Agile Gantt chart - removing weekend - PLEASE HELP!

[tamara390]

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.

[#2]

@tamara390 

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

[#3]

@Sergei Baklan 

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!

[#4]

Thanks a million. The formulas worked!!@Sergei Baklan 

[#5]

@CTyson , glad to help