I have a table of dates arranged in a vertical column. I would to enter a date and find the first date that is within 15 days of that date (-7 date +7). If no date in the table is within 15 days of the search date, I would like to return #N/A. Note that most of the dates in the look up column are separated by more than 7 days, but not all. I would prefer to use a native Excel function rather than a UDF, if possible.
See attached workbook for desired results and data.
Thanks!
Bookmarks