View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
SGT Buckeye SGT Buckeye is offline
external usenet poster
 
Posts: 33
Default Date / formula problem

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.