hi, I need to use linear interpolation, but I see that excel doesn't have a function for it. it does have trend, but i believe that's for linear extrapolation.
ive provided an example sheet. im looking for the answer of 1939, but trend gives me ~1907
any ideas for a formula?

thanks
TrendExample.xlsx