I would appreciate it if someone could take a look at the attached spreadsheet and tell me what I am doing wrong with the FORECAST.ETS.ADD function. The formula is located in C252
TIA,
David
johnson-n-johnson.ods (19.4 KB)
The timeline must have a “consistent” step.
From my experiments with your example I conclude that “equidistant” is accepted as “consistent”.
If your timeline (with changing steps) is “consistent” I can’t tell without a clear specification.
- If I replace your timeline with a contiguous sequence of “start of month” I get a result.
- If I create a contiguous sequence of “end of month” it fails.
May be a bug.
(I personally never use this kind of functions. Too cryptic. Too much faith needed,)