Home

Issues with Timeline for FORECAST.EST

%3CLINGO-SUB%20id%3D%22lingo-sub-721896%22%20slang%3D%22en-US%22%3EIssues%20with%20Timeline%20for%20FORECAST.EST%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-721896%22%20slang%3D%22en-US%22%3E%3CP%3EHello%20everyone%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20having%20issues%20when%20using%20the%20FORECAST.EST%20function.%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20forecast%20something%20on%20a%20daily%20basis%20within%20a%20month%20and%20I%20would%20want%20to%20base%20my%20forecast%20on%20data%20for%20the%20same%20month%20in%20previous%20years.%20For%20example%2C%20I%20want%20to%20forecast%20the%20data%20for%20every%20day%20of%20the%20month%20of%20June%20using%20the%20daily%20data%20of%20June%20for%20previous%20years.%3C%2FP%3E%3CP%3EI%20think%20the%20issue%20with%20this%20is%20rooted%20in%20the%20fact%20that%20the%20function%20does%20not%20recognise%20a%20constant%20time%20interval%20since%20there%20is%20a%20daily%20step%20within%20the%20month%20itself%20but%20the%20months%20are%20separated%20by%20a%20whole%20year.%3C%2FP%3E%3CP%3EAnyone%20has%20any%20recommendation%20on%20how%20to%20get%20around%20this%20issue%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-721896%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
jamesdoe735
Frequent Visitor

Hello everyone,

 

I am having issues when using the FORECAST.EST function.

I am trying to forecast something on a daily basis within a month and I would want to base my forecast on data for the same month in previous years. For example, I want to forecast the data for every day of the month of June using the daily data of June for previous years.

I think the issue with this is rooted in the fact that the function does not recognise a constant time interval since there is a daily step within the month itself but the months are separated by a whole year.

Anyone has any recommendation on how to get around this issue?

 

Related Conversations
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies