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
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]