Dates in a column

tiernosc

I want to write a formula where when I put in a start date in the first row, the next row in the same column will add a certain number of days and fill in that next date. I know this is something you can do in the rows, but I would like to do this in a column. Any suggestions on how this can be accomplished?

Kind regards,

Scott

Sameer Karkhanis

If you are not looking for a Column Formula then does the simple workaround of adding the formula

=[Start Date]1 + 3, work for you?

All you have to do is just drag the formula when you add new rows.

Kevin Smith

Hi, interesting challenge. My first thought is this sounds like Start Finish and Duration using the previous row as as Predecessor. These built in special fields might do what you need without having to build in lots of work and it would help if there is anything could cause your row order or inserted rows, etc. to cause problems. If this won't work, please explain more, they might still be some not so bad ways.

Sameer Karkhanis

If you are not looking for a Column Formula then does the simple workaround of adding the formula

=[Start Date]1 + 3, work for you?

All you have to do is just drag the formula when you add new rows.

Kevin Smith

@Sameer Karkhanis's solution is really good and simple if it works for you. You can even have the duration set to a column of values if you wanted different number of days added per row. Just remember to re-drag the formula for any inserts or order changes. Ex: =[Start Date]1 + [Duration Col]@row

tiernosc

I tried the formula that we would use when columns are next to each other, but I get a #circular reference. What I trying to accomplish is when I fill in the date associated with the Orientation the dates below will autofill based on pre-determined days allotted for each task. So, I would add one day to the date listed in the Orientation column it put it in the next row of the same column, and continue down the column, each date in the next row referencing and adding to the date listed directly above.

Paul H

@tiernosc As Kevin mentioned, it seem like you could use a standard project template with built in Duration and Predecessor columns