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.
    Genevieve P. Employee Admin
    Answer ✓

    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.