Simple Method to create Excel Gantt Chart with Dynamic Task Bar and Holidays Marker

This video will show you a simple method on creating Gantt Chart with Non Working Days and Holidays exclusion for your project using Microsoft Excel. The method will show you workdays task bar that will skip non working days as well as particular holidays in its table. And respective employee's workdays will be calculated automatically without those non working days.

This method is proven to be the easiest and the quickest one to be understood by any people with different excel skill level.

The main logic is to put value of 1 (it could be any values) for workdays task bar and other values for non working days. In this video I used value 0 for unused days, 1 for workdays, 2 for weekly non working days, and 3 for particular holidays. All values are wrapped within single formula in Gantt Chart table. Then, set conditional formatting formula to show color will be as easy as set specific colors to those values in each Gantt Chart cells.

And counting the number of workdays will be as easy as count the occurrence of value 1 in respective rows.

After seeing this, you can develop your Gantt Chart to have other values for other conditions. Or you can colorize specific dates in workday task bar to have different color, for example for showing current progress etc.