I think that is the function I need to use but not sure. I need to look at what is in cell a2, then look for a match in E:E, then take the number just to the right of the match in E and add it to today's date. Possible?
Sample sheet attached. Thanks for any help!
Bookmarks