S
SGT Buckeye
Please help. Can this be done? On WS 1, there is lookup criteria in
cell A2, a date in cell D2 and another date in cell I2. On WS 2,
there is a table with the lookup criteria in cells A2 thru A9. I
would like a formula to add the number of months from a cell in the
table on WS2 (vlookup) to the date in cells D2 and I2, compare the
two, and then return the date that is later.
cell A2, a date in cell D2 and another date in cell I2. On WS 2,
there is a table with the lookup criteria in cells A2 thru A9. I
would like a formula to add the number of months from a cell in the
table on WS2 (vlookup) to the date in cells D2 and I2, compare the
two, and then return the date that is later.