Hi,
I am forecasting sales by weight-average of last two months and multiply the average sales by working days of the months will be forecasted
I want excel to auto-detect the last two months by offset to forecast remaing months
You can find the file and explanations attached
Thanks for any idea
Bookmarks