This is probably something super simple.
But for some reason, i cant figure it out.

I have a list of dates in ascending order. (C2:C1000)
6/20
6/21
6/22
6/23
6/24
6/25
6/26
6/27
etc...

In A:2, i would i want to enter a specific date that is provided in
the date list above.
6/20

and return the value 10rows down.

Any suggestions?