Forecast in between remaining months

[fayez_MrExcel]

I have From (beginning of the month) and to Date (End of the month) e.g. from Jan-2021 - Sep2021 with a total of 150,000, how can i forecast the total remaining Oct, Nov & Dec.

Thanks

 

[GraH]

Do you have the data per month (per fixed interval) then you can use the forecast.est function.
Else you can adpot an alternative approach for a 'linear' forecast: when 9 months is 150,000 then 12 months would be 200,000. Delta is 50,000 spread over three months is 16,667 per month.
Depending on where you have your dates in your file you can write a formula that responds to the change in time accordingly.

There might be other approaches I do not know off.

 

[fayez_MrExcel]

Do you have the data per month (per fixed interval) then you can use the forecast.est function.
Else you can adpot an alternative approach for a 'linear' forecast: when 9 months is 150,000 then 12 months would be 200,000. Delta is 50,000 spread over three months is 16,667 per month.
Depending on where you have your dates in your file you can write a formula that responds to the change in time accordingly.

There might be other approaches I do not know off.

I have a data per month (all of it are starting from 1st day of the month) with actual values. Example, i manage to get the actual value result in a table from Jan - Sept, and i wanted to get the total forecast from Oct to Dec 2021.

 

[GraH]

Book1
	B	C	D	E	F	G	H	I	J	K	L	M
1	1/01/2021	1/02/2021	1/03/2021	1/04/2021	1/05/2021	1/06/2021	1/07/2021	1/08/2021	1/09/2021	1/10/2021	1/11/2021	1/12/2021
2	154	172	226	189	207	313	257	249	308
3	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	#N/A	308	287	300	364
Sheet1

Cell Formulas
Range	Formula
B3:M3	B3	=IF(AND(B2<>"",C2=""),B2,IF(B2<>"",NA(),FORECAST.ETS(B1,$B2:B2,$B$1:B$1)))