I would like to look-up a date in a range and find the date that is closest today's date and return that value to a cell (C2):
B2: Todays Date: 1/30/14
C2: Next Upcoming date ?
A1: 2/1/14
A2: 2/2/14
A3: 3/1/14
As an added challenge, if there is date in the range that is older than today’s date (past due), I would like it to return that value:
B2: Todays Date: 1/30/14
C2: Next Upcoming date ?
A1: 2/1/14
A2: 2/2/14
A3: 3/1/14
A4: 1/1/14
Bookmarks