Forecast for the month

[AV114]

Please help me to forecast formula for the year

 

[vletm]

AV114
Thread is 'forecast for the month'.
Next, You ask help to 'forecast formula for the year'.
Your file has two months values.
If would like to have some kind of 'forecasting' then there should be more data.
Month > Year > which period do mean?

 

[Chihiro]

Have a read of thread below.
https://chandoo.org/forum/threads/forecast-formula-in-excel-2007.35393/

Depending on algorithm being used, you'd want 15~19 months of data, especially when considering seasonal pattern. If not, you can get away with slightly less data points.