# Forecasting using past and current year

#### youngsc

##### New Member
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.

### Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number

#### CA_Punit

##### Well-known Member
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

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

#### gaz_chops

##### Well-known Member
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.

#### youngsc

##### New Member
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.

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

Replies
1
Views
150
Replies
5
Views
146
Replies
0
Views
100
Replies
7
Views
772
Replies
2
Views
96

1,129,752
Messages
5,638,162
Members
417,011
Latest member

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back