new to excel but have a complicated question

[sthaker]

Hi there,

I have created a project spreadsheet with a number of tasks and a number of due dates for these tasks...

I'm finding it a pain to have to go in and change all the dates by one day manually when a date for a particular task changes... is there a way to update the dates for the other tasks automatically?

In most cases, I have to update the date by one day, but there are many tasks, so it takes me ages..

hope someone can help....

S

 

[Lewiy]

Can you be a bit more specific? Do you need to change every date by one day or only certain ones? How do you know which ones need changing?