Share via

Forecast Sheet: Missing data and weekends - Excel 2016

Anonymous
2018-01-08T21:38:20+00:00

Hi, 

I am using the Forecast Sheet function in excel 2016 to create a forecast of daily calls data. I have data back to 2014 for every day but I have many values as 0's because of weekends and holidays. I am wondering how the Forecast functions work around weekends and holidays to provide accurate daily estimates.

Can the function tell which days are weekends and holidays and provide a forecast of 0, as call volume on those days would be 0?

Thanks, Charles

Microsoft 365 and Office | Excel | For home | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2018-01-09T03:10:39+00:00

    Hello Charles,

    Using a forecast aids in predicting things like future sales estimate, inventory requirements, or consumer trends. To know more information about how this works, we have a designated article to help you with this concern. See this reference: Create a forecast in Excel 2016 for Windows. This will provide you with helpful insights and procedures in creating, customizing, and applying formulas in forecasting data.

    Let us know if you have additional questions and we'll be happy to assist you.

    Was this answer helpful?

    0 comments