Gantt Chart

quigley · Apr 10th, 2002, 07:12 AM

Dear Mr Excel

I have created a Gantt chart in Excel as indicated in ‘tip of the week’ however I have utilised days instead of years as my unit of measure. I have also included an extra column which shows the number of days between the start and end date.

However I wish to exclude certain days of the week in this calculation i.e. Saturdays and Sundays (Non Working days). Therefore how can this be achieved?

I presume the conditional formating will not help in this situation and the weekday function only provides numbers 1 to 7.

Is there a formula that can do this, failing that will, a macro be required?

Regards

Anthony Quigley
Senior Business Analyst
Technology Enablement

 01204 376748 /0151 906 8759
 Anthony.Quigley@vertex.co.uk

Aladin Akyurek · Apr 10th, 2002, 07:22 AM

Have a look at:

http://www.xl-logic.com/pages/charts.html

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 10th, 2002, 07:12 AM	#1
quigley New Member Join Date: Apr 2002 Posts: 3	Dear Mr Excel I have created a Gantt chart in Excel as indicated in ‘tip of the week’ however I have utilised days instead of years as my unit of measure. I have also included an extra column which shows the number of days between the start and end date. However I wish to exclude certain days of the week in this calculation i.e. Saturdays and Sundays (Non Working days). Therefore how can this be achieved? I presume the conditional formating will not help in this situation and the weekday function only provides numbers 1 to 7. Is there a formula that can do this, failing that will, a macro be required? Regards Anthony Quigley Senior Business Analyst Technology Enablement  01204 376748 /0151 906 8759  Anthony.Quigley@vertex.co.uk

Apr 10th, 2002, 07:22 AM	#2
Aladin Akyurek MrExcel MVP Join Date: Feb 2002 Location: The Hague Posts: 50,317	Have a look at: http://www.xl-logic.com/pages/charts.html