Forward and backward planning on the same row?

Manu

Hello good people!

I am trying to set-up a sheet where I can plan forward OR backward but on the same row. Meaning, I f I enter a date in Col A it calculates a date value in Col B, but if I instead enter a date in Col B it calculates a date value in Col A. And I need to be able to switch back and forth ad-infinitum to test out scenarios.

Is that somehow doable?

Matt Stewart

You can setup 5 columns:

Column A and B are work forward.

Column C is duration for each row/task

Column D and E are work backward.

You then leave Row 1 of Column A as manual entry, and all other cells in column A should point to preceding task end in column B. Column B takes the start (column A) and adds the duration (column C).

Column E starts with the last row of Column E as manual entry. All other cells in column E would point to the start of successor task in Column D. Column D then takes the end (column E) and subtracts the duration (column C).

Matt Stewart

You can setup 5 columns:

Column A and B are work forward.

Column C is duration for each row/task

Column D and E are work backward.

You then leave Row 1 of Column A as manual entry, and all other cells in column A should point to preceding task end in column B. Column B takes the start (column A) and adds the duration (column C).

Column E starts with the last row of Column E as manual entry. All other cells in column E would point to the start of successor task in Column D. Column D then takes the end (column E) and subtracts the duration (column C).