FORECAST Formula

Theory:
=FORECAST(Month Number to predict, Range of sales for prior 12 months, Range of month numbers for the year from 1 to 12)
Sales Table:
          A           B
1     Month   Sales
2     1            2457
3     2            8544
4     3            4145
5     4            6425
6     5            7885
7     6            8643
8     7            2354
9     8            4235
10   9            8664
11   10          4627
12   11          9753
13   12          9999
Example:
=FORECAST(8,B2:B13,A2:A13)
You should open a new excel workbook and populate  cells A1 to B13 with the headers and data listed above. Then in a separate cell enter the formula above to see your prediction for the month of August (8).