add a day to entire project

jvalchine

with different due dates.. adding a day to one task will move all dates in project out... how to I do this withough manually having to enter each new date?

Genevieve P.

Hi @jvalchine

You can add a day to a Date by using + 1

=[Date Column]@row + 1

See: Use Formulas to Perform Calculations With Dates

However I'm not sure I understand what it is you're looking to do. Are you just looking to add a new task to a Project sheet without adjusting all the current tasks? In this case, you'll just need to make sure you don't add any Predecessors to that row.

If this hasn't helped, it would be useful to see a screen capture of your sheet, but please block out sensitive data.

Cheers,

Genevieve

Christian Graf

Make a new column for the new date.

enter this formula where the original date column is date@row:

=DATE(YEAR(Date@row), MONTH(Date@row), DAY(Date@row) + 1)

jvalchine

okay christian I entered the following as you stated and nothing worked..:

date@row:=DATE(YEAR(Date@row), MONTH(Date@row), DAY(Date@row) + 1)

jvalchine

did I enter the formula correctly?

Genevieve P.

Hi @jvalchine

You can add a day to a Date by using + 1

=[Date Column]@row + 1

See: Use Formulas to Perform Calculations With Dates

However I'm not sure I understand what it is you're looking to do. Are you just looking to add a new task to a Project sheet without adjusting all the current tasks? In this case, you'll just need to make sure you don't add any Predecessors to that row.

If this hasn't helped, it would be useful to see a screen capture of your sheet, but please block out sensitive data.

Cheers,

Genevieve

jvalchine

genevive i do not understand predecessors. can you give me a clifnotes on when you use them and for what purpose? I am new to this and learning!!

jvalchine

by adding a day to one of the tasks .. I want it to automatically add a day to all the tasks including the complion date of the project. this way i wont have to reenter every date for every task.. does this make sense? can support help me ?

Genevieve P.

Hi @jvalchine

Predecessors link your tasks together. You add the row number that your current task is dependent on, and then that way if you change the date of an earlier task it will automatically push out any tasks that are dependent on it!

Here's a Help Article that goes through Predecessors: Enable Dependencies and Use Predecessors

If you're new, you may want to watch this free Webinar on Project Settings that talks about task relationships: SmartStart: Project Management

Cheers,

Genevieve