Statistical Prediction

[stroffso]

I have a table which has 8 Columns. I have data put in weekly for the last 3 years with the example being below. What i want is a formula that will predict what the next 6 months of data would be in rows ranging from batch 103 onwards. I need a simple formula with cell references that take into account all the numbers, each numbers occurrence tally, establish trends based on number occurence frequency and trends, to accurately forecast the next set of numbers to occur if that makes sense? A formula that applies forecast,including trends, linear regression, mobile averaging and exponential and logarithmic options, that can be applied as a formula in a cell that doesn't require graphs or tables.As simple as possible needed, thanks in advance

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]Batch[/TD]
[TD]Date[/TD]
[TD]Sales1[/TD]
[TD]Sales 2[/TD]
[TD]Sales 3[/TD]
[TD]Sales 4[/TD]
[TD]Sales 5[/TD]
[TD]Sales 6[/TD]
[/TR]
[TR]
[TD]101[/TD]
[TD]22/07/16[/TD]
[TD]5[/TD]
[TD]2[/TD]
[TD]22[/TD]
[TD]23[/TD]
[TD]41[/TD]
[TD]23[/TD]
[/TR]
[TR]
[TD]102[/TD]
[TD]29/07/16[/TD]
[TD]5[/TD]
[TD]6[/TD]
[TD]12[/TD]
[TD]44[/TD]
[TD]7[/TD]
[TD]24[/TD]
[/TR]
[TR]
[TD]103[/TD]
[TD]05/08/16[/TD]
[TD]Formula[/TD]
[TD]Formula[/TD]
[TD]Formula[/TD]
[TD]Formula[/TD]
[TD]Formula[/TD]
[TD]Formula[/TD]
[/TR]
</tbody>[/TABLE]

 

[stroffso]

Can anyone help with this?