Forecast or Trend formula

[robb7833]

I am trying to come up with a formula that would show what the next number would possibly be. I think it is probably much easier than I am making it. I have some dates and numbers below and they are for readings that should be turned in but if they are not we need a formula to estimate what would be the next reading would be based on the information we already have.

10/22/2012	89262
11/20/2012	90991
12/18/2012	92769
1/29/2013	94269
2/28/2013	95769

<colgroup><col style="mso-width-source:userset;mso-width-alt:2596;width:53pt" width="71"> <col style="width:48pt" width="64"> </colgroup><tbody>
</tbody>

I need to have some sort of formula that would give the next number that isn't obviously just giving 1500 added to it. The next number should always be higher than the last.

 

[JoeMo]

Presumably the next number depends on the next date. In the example below, the next date is assumed to be 3/28/2013.

Excel Workbook
	A	B
1	Date	Number
2	10/22/2012	89262
3	11/20/2012	90991
4	12/18/2012	92769
5	1/29/2013	94269
6	2/28/2013	95769
7	3/28/2013	97257
Sheet3

 

[robb7833]

Presumably the next number depends on the next date. In the example below, the next date is assumed to be 3/28/2013.
Sheet3

*	A	B
1	Date	Number
2	10/22/2012	89262
3	11/20/2012	90991
4	12/18/2012	92769
5	1/29/2013	94269
6	2/28/2013	95769
7	3/28/2013	97257

<colgroup><col style="font-weight:bold; width:30px; "><col style="width:75px;"><col style="width:58px;"></colgroup><tbody>
</tbody>

Spreadsheet Formulas

Cell Formula B7 =ROUND(TREND(B2:B6,A2:A6,A7),0) <tbody> </tbody>

<tbody>
</tbody>

Excel tables to the web >> Excel Jeanie HTML 4

awesome thank you!! thats exactly what I needed.