Friday, August 22, 2014

yogi_Given A Start Date In Cell A2 Compute Dates In Successive Rows A3 And Down By Cumulatively Adding Needed Days In B3 And Down

                       Google Spreadsheet   Post  #1732
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI     www.energyefficientbuild.com.   Aug-22-2014
post by MikeWallaceDev :
(https://productforums.google.com/forum/#!category-topic/docs/spreadsheets/2OJO9xOzLTY)
How to refer to a previous cell in the same column
Hi,

I am trying to create a schedule in a sheet.  I'm trying to create a column with dates that will increment based on the date in the cell above + a values in a column.  

What I want to achieve looks like this : 












The first date (2014-09-18) will be entered manually and depicts the actual start of the project.  All of the other dates below that date should be created by adding the number of days in the "Days needed" column.

(assuming that what we see in this bitmap is column A, B and rows 1, 2, 3, ...)

I have tried this : (in cell A3) =ArrayFormula(A2:A+B3:B) but this gives me a circular reference. And I don't understand why...

so, from my understanding (regardless of the fact that it doesn't work) this formula should give me something like : 
A3=A2+B3
A4=A3+B4
A5=A4+B5 and so on.  

How would I go about getting this to work?

Thank you

-MIke
--------------------------------------------------------------------------------------------------------------------------------------


No comments:

Post a Comment