Advanced repeating rows. Start date after preivous end date..

[Jeremy]

How do I make this work, just need repeating table/rows. I can do this
correctly other then setting the first start date. How do I specify to use
the End Date of the Previous row not the current row?

I hope this helps explain:

What I need

Project Start Date: 01/01/08

Repeating Table
PHASE WKS Delay Phase Start Date Phase End Date
01 1 0 01/01/08 01/07/08
02 2 0 01/07/08 01/21/08
03 1 0 01/21/08 01/28/08

"Phase Start Date" = "addDAY(Project Start Date, (Delay*7))"
"Phase End Date" = "addDAY(Phase Start Date, (Phase WKS*7))" [*7 because I
need weeks not days]

My problem starts here, the first row works great but the second row's Phase
Start doesn't start from Phase End Date but from Project Start Date.

If I change Phase Start Date: to ="addDAY(Phase End Date, (Phase WKS*7)) -
This starts looping and fails out as expected.

How do I use one expression for the first row to give a start date but
change the expression for the second row to Phase Start date = End of
previous phase.


What I get now

Project Start Date: 01/01/08
PHASE WKS Delay Phase Start Date Phase End Date
01 1 0 01/01/08 01/07/08
02 2 0 01/01/08 01/14/08
03 1 0 01/01/08 01/07/08