project dates

I've created a Critical Path for a project, shown in the image. Columns C & D are the Start and End Dates respectively, and I'm keen for the subsequent cells (here F5:AP44) to automatically fill with colour (say, light blue) as the Start & End Dates are updated. I've seen it done in a previous...

Hey all, I'm building a collection of very high-level project timelines for a quick snapshot of where a project currently stands. This is all based on the dates / date ranges I'm given by Project Managers, and then have to manually extend and move the visual timeline references around. *Edit*...

Hi, I'm trying to prepare a study schedule/planner based on certain conditions: Week starts on Monday Study hours/day: 4 hours (Mon - Wed) & 12 hours (Thur - Sun) Topics are assigned a time limit and will roll over to a new day until time limit expires. In case a topic ends midway through a...

I have a data table tracking the number of hours for a specific project. Row one is headers for columns A and B and dates for columns C:DY. The projects are in column "A" and the total estimated hours in column "B". I then am taking the total estimated number of hours and am dividing them up in...

I have a training program with a fixed end date and 14 tasks associated with it The tasks have starting dates calculated across the time allowed. I need a formula that will recalculate the starting dates of the remaining tasks as others are completed I have a calculation that gives me the...

Thanks for reading this I have x amount of tasks in a project over a specific time frame The allocated time for each task can vary i.e. they have a start and end date for each specific task I need to be able to change the amount of time (both start and end dates) allocated if the project is...