Victoria is the southernmost major city in Western Canada, and is located about 100 kilometres (60 miles) from BC's largest city of Vancouver on the mainland.
Henry Gantt, a mechanical engineer, invented the Gantt chart in the 1910s. He designed his chart so that production foreman could watch schedules to ensure the work was being done on time. Gantt charts were used when building the Hoover Dam and for organizing large projects.
To build a Gantt chart, you can use Conditional Formatting with a formula based on the AND function. In the example shown, the formula applied to D5 is: =AND(D$4>=$B5,D$4<=$C5) How this formula works The... Note: Excel has several built-in data validation rules for dates.