Gantt project planner

%3CLINGO-SUB%20id%3D%22lingo-sub-1930606%22%20slang%3D%22en-US%22%3EGantt%20project%20planner%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1930606%22%20slang%3D%22en-US%22%3E%3CP%3EPlease%20i%20need%20help%20on%20how%20to%20make%20the%20Gantt%20project%20planner%20template%20to%20exclude%20weekends%20and%20holidays%20from%20painting%20it.%20attached%20is%20the%20file.%26nbsp%3B%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1930606%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1930651%22%20slang%3D%22de-DE%22%3ESubject%3A%20Gantt%20project%20planner%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1930651%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F881314%22%20target%3D%22_blank%22%3E%40mesfinM%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENot%20sure%20if%20this%20is%20it.%3CBR%20%2F%3ETake%20a%20look%20at%20the%20file.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1930738%22%20slang%3D%22en-US%22%3ERe%3A%20Gantt%20project%20planner%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1930738%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F881314%22%20target%3D%22_blank%22%3E%40mesfinM%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EDo%20you%20mean%20Plan%20Duration%20shall%20be%20in%20workdays%2C%20not%20in%20calendar%20days%3F%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20210px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F235985i32EDE3A94D7C9715%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
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

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

@mesfinM 

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

image.png

@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

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