Good evening. I am really struggling with this one. The FORECAST.ETS function and Forecast Worksheet tool are both new to me.
I have a set of data (attached)
The Data! sheet contains the raw data (dates and values)
Using the FORECAST.ETS function I have calculated the predicted rate on 12/31/2019
I have also used the same data to create a Forecast Worksheet. The forecast Worksheet has created 4 additional dates and values (I think using interpolation??)
How would I write the function to include the calculation of these additional "interpolated" values?
Please see attached
Bookmarks