Gantt project planner

New Contributor

Please i need help on how to make the Gantt project planner template to exclude weekends and holidays from painting it. attached is the file.  

5 Replies



Not sure if this is it.
Take a look at the file.


I would be happy to know if I could help.



I know I don't know anything (Socrates)


Do you mean Plan Duration shall be in workdays, not in calendar days?


@Sergei Baklan 

YES, let's say my plan starts on Tuesday, the plan duration is 6 days. I want the planner to exclude Saturday and Sunday, I tried the weekend function, but didn't work well for me.

Thank you for your help


on the excel you attached, the plan duration is 8 days but it only colored 6 days, I think the planner still considered Saturday and Sunday as a working day.  what I was looking for is to not consider Saturday and Sunday as a working day and also not to color Saturday and Sunday. 

thank you thou 

I only changed the conditional formatting, so that there is no color for the weekend, as you wished at the beginning.

I wish you continued success in your project with Excel

I know I don't know anything (Socrates)