Forecast Filtering Certain Days Of Week

[ReeceSeps]

I have a range of data. I want to create a forecast and have a seperate forecast for each day of the week. Monday, Tuesday e.c.t.

[#2]

@ReeceSeps 

If you have Excel in Office 2016 or later or in Microsoft 365, you can use the FORECAST.ETS function.

If you specify 7 for the Seasonality argument, the function will take weekly variability into account.

If there is a clear weekly pattern, you can even omit this argument.