Hello -

I have a data set similar to below

Date Field 1 Field 2 Field 3
1/1/09 x x o
1/2/09 o x x
1/3/09 o o x

I have another field which auto-populates today's date when the workbook is
refreshed. The formula for that is: =TEXT(TODAY(),"mm/dd/yy")

I would like to use Match to find the row with the closest date to todays
date.

Any help would greatly be appreciated.

Thank you for your time.