Hi Guys, look:

Cells C3:C36 have a series of dates stretching forward in time
Cells D3:D36 have a series of increasing values corresponding to those dates
Cell A1 has a specific date.

I would like an elegant way for the following: Scan the date range and find the 2 dates in between which my date falls, interpolate linearly using their corresponding values in column D so that I can get an interpolated value for my initial date. Thanks guys!