add a day to entire project
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?
Best Answer
-
Genevieve P. Employee AdminYou 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
Answers
-
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)
-
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)
-
did I enter the formula correctly?
-
Genevieve P. Employee Admin
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
-
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!!
-
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. Employee Admin
Predecessors link your tasks together. You add therow numberthat 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
