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]how's your VBA knowledge?