Gantt project planner

[mesfinM]

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.  

[#2]

@mesfinM 

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

I would be happy to know if I could help.

Nikolino

I know I don't know anything (Socrates)

[#3]

@mesfinM 

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

[#4]

@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.

[#5]

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 

[#6]

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

Nikolino
I know I don't know anything (Socrates)