Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Date / formula problem
Short on detail, but I think it is going to be something like:
=MAX(DATE(YEAR(D2),MONTH(D2)+your_lookup,DAY(D2)), I2) where your_lookup will be of the form: VLOOKUP(A2,Sheet2!A2:B9,2,0) This assumes the formula is in WS 1 - if not, then you'll need to include the sheet reference with D2 and I2. Hope this helps. Pete On Jan 18, 8:08*pm, SGT Buckeye wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date Formula Problem - Leave date blank if Null | Excel Worksheet Functions | |||
Date Format - Formula Problem | Excel Discussion (Misc queries) | |||
Problem with Formula (Date) | Excel Discussion (Misc queries) | |||
Date formula problem | Excel Discussion (Misc queries) | |||
Date formula problem | Excel Discussion (Misc queries) |