Gantt Chart In Excel

[kins]

hi

I have a gantt chart in excel and i have the following dates colored

06/11/2017 - 14/11/2017. The duration of the project is 9 weekday so I want the cells to color weekday. My start date and end date to the left is fine and excludes weekend (because I've put a weekday formula in) but I don't know how to get the actual chart color to change.

Any ideas?

 

[thisoldman]

Two functions that may help you are WORKDAY and NETWORKDAYS. If your weekends do not fall on Saturday and Sunday, you would use WORKDAY.INTL and NETWORKDAYS.INTL.

WORKDAY will return the date, before or after a starting date, excluding weekends and, optionally, excluding a list of holidays.
=WORKDAYS(start_date, days_between, list_of_holidays)

NETWORKDAYS will return the number of days between two dates, excluding weekends, and optionally, excluding a list of holidays.
=NETWORKDAYS(start_date, end_date, list_of_holidays)

A listing of Youtube tutorials by Mike Girvin that may be of interest:
https://www.youtube.com/user/ExcelIsFun/search?query=gantt