Gantt chart

I made some corrections to your worksheet so you don't get those errors but could not figure out what you are trying to do. Can you describe what you are trying to achieve? and by the way I had to use my 2003 excel since I do not have 2007 version but they are similar anyway with extra columns and functions.

Cheers!