Ok, this may sound kind of strange. We are trying to find an excel formula that would compare a column of dates and identify the closest dates to the current date.
Today dates = 11/27/2017
List of dates:
The result should be:
We have tried it with =MAX(($B$6:$B$20<TODAY())*B6:B20), but 2 things:
1. If a "past" date is the closest, it display THAT row (we don't want that - we want "after" current date)
2. If we get the formula, how can we calculate the "next" nearest date?