Forecasting the next number in a list?

[King Mustard]

Is there a formula that I can put next to the final date that will "forecast" the number?

My car contract allows 12,000 miles per year and I'm checking if I'm estimated to hit it.

 

[alansidman]

this forum does not allow for attachments. Suggest you post (upload) to a third party site or be specific/descriptive in your requirements.

 

[King Mustard]

this forum does not allow for attachments. Suggest you post (upload) to a third party site or be specific/descriptive in your requirements.

Done

EDIT: I was unable to edit my original post so I'll add this here. This worked: =FORECAST.LINEAR(A9,B2:B8,A2:A8)

 

[King Mustard]

Done

EDIT: I was unable to edit my original post so I'll add this here. This worked: =FORECAST.LINEAR(A9,B2:B8,A2:A8)

Link to answer source. Bit rubbish that you hardly get any time to edit posts. I post regularly on dozens of forums and this is by far the most restrictive.

 

[Peter_SSs]

Bit rubbish that you hardly get any time to edit posts.

You have 10 minutes. We found that if a lot of time is allowed, posts get a number of responses & then later an earlier post is significantly edited (or deleted), rendering those subsequent posts meaningless. To some extent that happened here with post 2 sounding like you didn't post any sample data in post 1, when in fact you did - but only in your edit.

It is easy to just add another post correcting or clarifying an earlier one if you miss the 10 minutes.