Computer Hope

Software => Computer software => Topic started by: Space_Cowboy1 on October 11, 2017, 03:02:16 PM

Title: Excel lookup/index/reference problem
Post by: Space_Cowboy1 on October 11, 2017, 03:02:16 PM

Please see attached screenshot of excel file.  Cells C8:G11 are formatted as date mm/dd/yy
row 6 shows the number of forecasted days to end date. 

here is the goal - I want to find the rightmost non-blank value in each row, then add the number of days in row 6 from the same column, and drop the result in column g of that row.

So,  cell g8 should say 10/17/17 because it adds the value of 6 (from c6) to the date in c8
cell g9 should say 10/18/17 because it adds the value of 3 (from d6) to the date in d9
cell g10 should say 10/23/17 because it adds the value 2 (from f6) to the date in e10

and, oh yeah, one more thing....  If I add a value to the right of an existing date, I want the forecasted(http://) end date to recalculate - so, given the sample data, if I add 10/14/17 to cell d8, I want cell g8 to now reflect 10/14/17 plus 3 (from cell d6) -- and deposit 10/17/17 in cell g8.

Your time and help are appreciated!

                     


[attachment deleted by admin to conserve space]

Title: Re: Excel lookup/index/reference problem
Post by: Mark. on October 15, 2017, 03:00:36 PM

how's your VBA knowledge?