### FORECAST.ETS(target_date, values, timeline [,seasonality] [,data_completion] [,aggregation])

Returns the future value based on historical values.

 target_date The date you want to predict. values The historical values. timeline The array or range of cells. seasonality (Optional) A number indicating whether to use seasonality:1 - automatically detected uses positive whole numbers (default)0 - no seasonality, therefore linear data_completion (Optional) A number indicating how to handle missing points:1 - use the average of the neighbouring points (default)0 - use zero for any missing points aggregation (Optional) The type of function to use:1 = AVERAGE (default)2 = COUNT3 = COUNTA4 = MAX5 = MIN6 = MEDIAN7 = SUM

#### Remarks

 * Added in Excel 2016.* ETS stands for Exponential Triple Smoothing.* The Aggregation Function will only be used when several values have the same time stamp.* If "timeline" and "values" are not the same size, then #N/A is returned.* If "timeline" contains duplicate values, then #NUM! is returned.* If "seasonality" is left blank, then 1 is used.* If "seasonality" > 8760, then #NUM! is returned.* If "data_completion" is left blank, then 1 is used.* If "aggregation" is left blank, then AVERAGE is used.* If "aggregation" > 7, then #NUM! is returned.* If "aggregation" < 1, then #NUM! is returned. Example 7* If any of the arguments are not numeric, then #VALUE! is returned.* The dates in the "timeline" must have a consistent step between them and can't be zero.* If a constant step cannot be identified in the "timeline", then #NUM! is returned.* You can use the FORECAST.LINEAR function to * You can use the FORECAST.ETS.CONFINT function to* You can use the FORECAST.ETS.SEASONALITY function to* You can use the FORECAST.ETS.STAT function to* For an illustrated example refer to the page under Advanced Functions.* For the Microsoft documentation refer to support.office.com

 A B C D 1 =FORECAST.ETS(B7,D1:D6,B1:B6) = 70 1/1/2019 43466 10 2 =FORECAST.ETS(43472,{10,20,30,40},{43466,43467,43468,43469}) = 70 1/2/2019 43467 20 3 =FORECAST.ETS(B7,D1:D6,B1:B6,1,1,1) = 70 1/3/2019 43468 30 4 =FORECAST.ETS(B7,D1:D6,B1:B6,1,1,2) = 1 1/4/2019 43469 40 5 =FORECAST.ETS(B7,D1:D6,B1:B6,1,1,3) = 1 1/5/2019 43470 50 6 =FORECAST.ETS(B7,D1:D6,B1:B6,1,1,4) = 70 1/6/2019 43471 60 7 =FORECAST.ETS(B7,D1:D6,B1:B6,1,1,0) = #NUM! 1/7/2019 43472