Hi Scaffold
Firstly, as an experience project manager of some 30 years plus I would strongly recommend you use a planning tool such as MS Project for this. However if you dont have access to MS Project then may I suggest you post a sample of your spreadsheet so we can see exactly what your isue is and we would be better prepared to help you.
Tony (OTPM)