FORECAST.ETS
Returns a forecasted value for a specific future target date using exponential smoothing
Syntax
FORECAST.ETS(target_date, values, timeline, [seasonality], [data_completion], [aggregation])
Parameters
- target_date: Required. The data point for which you want to predict a value
- values: Required. The historical values
- timeline: Required. The independent array or range of dates or numeric data
- seasonality: Optional. The length of the seasonal pattern (default auto-detected)
- data_completion: Optional. 0=missing points treated as zero, 1=missing points completed by interpolation (default)
- aggregation: Optional. 1=AVERAGE (default), other aggregation methods
Example
=FORECAST.ETS(DATE(2025,1,1), B2:B14, A2:A14)