How to create Automated Gantt Chart using Google Sheet

Creating a complex formula to produce a simple output takes time and patience as sometimes what you think will work simply just won’t work out immediately. Sometimes, you have to do trial and error, not only once but multiple times. You combine one formula to the other, test, research and try again until you will get it right. To save your time and your head from aching, I have here a simple Gantt Chart generator. All you have to do is provide or input the start and end date, then the duration of the activity or milestone. The graph will then be generated without manually formatting it.