open to cell
 

How do i open a workbook to a cell using a referance formula, example (I have
a auto update date set in a1 and a list of other dates below, how would I
have the workbook open to the date that is the closest to ref:a1)?