Forecasting current sales according to ongoing trend and history data

manchoon

New Member
Joined
Feb 17, 2016
Messages
8
Hello everyone, hope you'll be able to help me
smile.gif


I have everyday sales data of this month and I need to forecast daily sales till the end of this month. I have to take into consideration the ongoing trend and also the history sales of the same month of previous year. The solution has to be refreshable, I mean after I refresh the data and new daily sale is added in current month, the forecast should update too.
This is my chart. Blue line is current sales, red one is previous year (the same month) sales. I need blue line to be continued with for example orange line which will show forecasted everyday sales.
538206d1505457851-forecasting-current-sales-according-to-ongoing-trend-and-history-data-ag.png

I tried to do it with forecast sheet (from data tab), which does the instant forecast, but it either does linear forecasting which is not correct or I have to indicate seasonality, but I don't have seasonality, it's one month and every day sales are different. It doesn't show prev year sales too. So I guess it won't be useful for me.

Could you please tell me which tool to use or any formula?
Any ideas?

please help
Thank you in advance.
 

Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

Forum statistics

Threads
1,213,560
Messages
6,114,304
Members
448,564
Latest member
ED38

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.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

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

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

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
Back
Top