Returns the length of the repetitive pattern Excel detects for the specified time series. FORECAST.ETS.SEASONALITY can be used following FORECAST.ETS to identify which automatic seasonality was detected and used in FORECAST.ETS. While it can also be used independently of FORECAST.ETS, the functions are tied since the seasonality detected in this function is identical to the one used by FORECAST.ETS, considering the same input parameters that affect data completion.
| Excel version | Available |
|---|---|
| Excel 2007 | ✗ |
| Excel 2013 | ✗ |
| Excel 2019 | ✓ |
| Excel 2021 | ✓ |
| Microsoft 365 | ✓ |