Forecasting using past and current year

[youngsc]

I know there's a way but I'm drawing a blank on best approach and method. I have one rolling year of data so say July 2019 to June 2020. However, on the report I'm only showing year to date so January to June. What I'd like to be able to do is from July to December provide a projection based on past July to December and current January to June. This would be in a table not a chart. I'm really just needing to know the best formulas or methodologies to use so I can google it or start working through a solution.

 

[CA_Punit]

How is the forcasting Based on. There are various estimates and other details which you might need to consider.
Criterias are important so i think you should consider the assumptions and criteria in the forcast first before jumping to excel

 

[youngsc]

With this i don't really have any other variables to go off of. It's simply an, albeit broad, estimation

 

[CA_Punit]

albeit broad, estimation

I don't know about this technique

 

[youngsc]

I don't know about this technique

Cool helpful

 

[gaz_chops]

I think you need to provide more information as to what you actually want help with? Maybe start by using XL2BB to post a sample of what your data looks like, what you are trying to achieve with examples of the results you expect.

Help us to help you

 

[youngsc]

I think you need to provide more information as to what you actually want help with? Maybe start by using XL2BB to post a sample of what your data looks like, what you are trying to achieve with examples of the results you expect.

Help us to help you

Sorry trying to do everything from my phone made it more difficult cause I couldn't do a table. I have financial data for the entire prior calendar year. I have financial data for current year to date. I'd like to the using those two data forecast for the rest of the current year.

So if a table helps, using the below 2019 data for July to December and the 2019 and 2020 data for January to June how can i build a forecast for July or July through December?

	January	February	March	April	May	June	July	August	September	October	November	December
2019	50	35		15	25	70	50	45			30	25
2020	45	28	5	7	22	50