Easy Excel Gantt Charts - Perfect for Project Management

Hello Mynda,
I've created a Gantt Chart, however, i have a problem in the formula [=IF(H16>=1, WORKDAY.INTL(I16, INT(H16), "0000011") + IF(MOD(H16,(INT(H16)))>=1, TIME(12, 0, 0), 0), WORKDAY.INTL(I16, INT(H16), "0000011") + IF(H16>=1, TIME(12, 0, 0), 0))]. Here the Col. H is duration, Col. I start date, end date is calculated in Col. J. Now the issue is when the task requires 1 day to complete instead of the output result being the same day, it is taking an extra day and resulting in the next day as end date. I need the end date to be the same day, similarly if the task requires 2 days and the start day falls on a Friday, the end date should be the following Monday, which excludes the weekends. Pls help

Thank you Mynda, I learned a lot from your videos. I have a question, why did you use 'isblanck", instead of =IF(B5 = " ", " ", ....

Very Cool. Enjoyed this example for project management visualization

Hello Mynda, I am having trouble for the formula if my completed days are in the same column as the estimated days since I want to show to bar graph for estimated and completed in parallel. Thank you in advance.

Hello, do you have a video or tutorial on how to set up task dependencies within an excel worksheet?

AND(ISNUMBER(B2),LEFT(CELL("format",B2),1)="D")

I am using this formula as conditional for to restrict data other than date.

But the thing is that this condition is not working online mode, it shows an error.

So can you help me on this. I want to restrict a column to enter date only.

I'm having issues with the formula. I put everything in however it doesn't highlight anything. Please help 🥺

Great tutorial, this is better than buying MS Project and it integrates better into program management dashboards.

Ooooh - this looks very useful. I use MSP a lot but it's not easy to read if you're not a regular user; these charts are a lot more accessible.

Great video Mynda, however, is there a week function rather than days? Just so you can compress the Gantt field of view..

I have a slightly different technique. Instead of having the logic in the conditional formatting I have it all in the formulas. And the result is a number (1,2,3) or a short text (ok,x,bad) with the status and an empty string if nothing. And then I apply the conditional formatting to the value (e.g. if value = 2 then font and background green)
Thanks to that I can use other formulas (like countif) to reference this. Like count the number of overdue days etc.
But with what you gave, it’s easier to change the priority of colours and give comments directly in the cells.

your videos help me a lot thank you very much. I also share your videos to collegues also. You are very talented.

Great and easy to make 👌 Thanks

Thank you, it's very useful...

Hi Mynda, truly amazing!!👌🏻 Thank you so much for this video on Gantt Charts. Really means a lot to me. You're really helping many professionals like me to develop ourselves, gain knowledge & explore more.

Take care & stay blessed.

Excellent Mynda! Thank you!

Dear Mynda, it looks absolutely fantastic!
Would use that at work.

Was all set to see the use of dependencies on tasks and the effects of a change or delay of one item and how it affected the rest. But for a standard training representation of how to format using conditional data in a real life gant chart, this was very good

Wait.. what was that 'Double-Click' thing to Auto enter all the formatting data ?

🙂...Genial, gracias por compartir estos muy interesantes aportes. Me suscribí desde que vi tu primer video ....👍

Excellent as always, Mynda. Thank you very much for sharing such valuable knowledge that results in a profound improvement of our professional development.

the portion of the first formula will return the false condition every time. Simple example: =IF(ISBLANK(A2)="","True", "False") is incorrect. To have the formula work correctly, it should read =IF(ISBLANK(A3),"True", "False")

Hi Mynda!Really Great Tutorial,Will Definitely Be Trying This Cool Technique Out...Thank You :)

Good approach to conditional formatting in a Gantt chart. Thank you very much Mynda. The issues of the channel are very practical.

Thank you for this great tutorial

Wonderful. Very useful tutorial.

Not useful at all... (just kidding). Excellent tutorial (as always) 😊

Excellent video as always - thanks!

I wish Excel allowed you to create names for conditional formatting rules - it would be so much easier to understand what potentially complex formulae are doing if instead of seeing the formula in the manage rules dialogue, you saw a user defined name that described the result of the formula.

Thanks Mynda! I've used something similar before but I like yours a bit better.

Great stuff, thanks Mynda!

I had used this technique before. But yours have lots of layers. Thanks for sharing. Loved it.

God bless, first to Comment