Forum Discussion
Gantt project planner
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.
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)
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
Nikolino
I know I don't know anything (Socrates)