FORECAST.ETS.SEASONALITY Function
Returns the length of the repeating pattern Excel detects in a time series.
Category
Statistical
Available in
Excel 2016+, Microsoft 365
Returns
A whole number
Overview
FORECAST.ETS.SEASONALITY returns the season length that FORECAST.ETS would detect automatically — for example 4 for a quarterly cycle, 12 for a yearly cycle in monthly data, or 7 for a weekly cycle in daily data. 0 means no repeating pattern was found.
Use it to check the automatic detection, or to show the detected cycle next to a forecast.
Syntax
Arguments
| Argument | Required? | What it does |
|---|---|---|
| values | Yes | The historical values. |
| timeline | Yes | The dates or period numbers, with a constant step. |
| data_completion | No | 1 (default) fills missing points with the average of their neighbours; 0 treats them as zero. |
| aggregation | No | How to combine values with the same date: 1 AVERAGE (default), 2 COUNT, 3 COUNTA, 4 MAX, 5 MEDIAN, 6 MIN, 7 SUM. |
Examples
Example 1 — Detect the quarterly cycle
Three years of quarterly sales.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Quarter | Sales | Season length | |
| 2 | 1 | 95 | 4 | |
| 3 | 2 | 115 | ||
| 4 | 3 | 135 | ||
| 5 | 4 | 105 | ||
| 6 | 5 | 115 | ||
| 7 | 6 | 135 | ||
| 8 | 7 | 155 | ||
| 9 | 8 | 125 | ||
| 10 | 9 | 135 | ||
| 11 | 10 | 155 | ||
| 12 | 11 | 175 | ||
| 13 | 12 | 145 |
The pattern repeats every 4 quarters.
Common mistakes
- #NUM! The timeline has no constant step or too many missing points.
- #N/A values and timeline are different sizes.
- Short histories. A cycle can only be detected when the history covers it at least twice.
Notes
- Related functions: FORECAST.ETS, FORECAST.ETS.STAT.

Author
Kyle Stott
Certified Microsoft Excel Expert
Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.