Excel Gantt Chart Help

**chrisdantonelli** · 10-02-2015, 08:45 AM

Greetings,

I have created a gantt chart out of excel, 2007, and I am having trouble taking into account for weekends. I have a list of approx 40 tasks with varied durations, and I am able to make the chart work for 7 days a week, but how do I make the dates account for the weekends as the people completing the tasks only work Mon-Fri and not on major holidays. Any help would be appreciated.

**tim201110** · 10-02-2015, 11:15 AM

function workday'll be some help

**newdoverman** · 10-02-2015, 11:51 AM

Here is a Gantt chat that may help you get started. It has the weekend columns without dates and uses Conditional Formatting to form the bars in the chart.