What is the syntax for FORECAST.ETS.SEASONALITY in Excel?

The syntax for FORECAST.ETS.SEASONALITY is: =FORECAST.ETS.SEASONALITY(values, timeline, [data_completion], [aggregation])

What are common errors with FORECAST.ETS.SEASONALITY?

Returns 0 if no seasonality detected

How do I use the FORECAST.ETS.SEASONALITY function?

To use FORECAST.ETS.SEASONALITY, type =FORECAST.ETS.SEASONALITY( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.

What type of data does FORECAST.ETS.SEASONALITY work with?

FORECAST.ETS.SEASONALITY works with numerical data and can handle ranges, arrays, and individual values. It ignores text values and empty cells in its calculations, focusing only on numeric data for accurate statistical analysis.

Why is FORECAST.ETS.SEASONALITY not working in my Excel?

Common issues with FORECAST.ETS.SEASONALITY include Returns 0 if no seasonality detected. Start by checking the syntax =FORECAST.ETS.SEASONALITY(values, timeline, [data_completion], [aggregation]), then verify each referenced cell or range.

Statistical

FORECAST.ETS.SEASONALITY Function in Excel

Returns the length of the repetitive pattern Excel detects for the specified time series.

Syntax

=FORECAST.ETS.SEASONALITY(values, timeline, [data_completion], [aggregation])

Arguments

values (required): Historical values
timeline (required): Historical dates
data_completion (optional): Handle missing data
aggregation (optional): Aggregation method

Examples

=FORECAST.ETS.SEASONALITY(B2:B25, A2:A25) - Detect seasonality - Result: 12 (monthly)

FORECAST.ETS.SEASONALITY for data analysis

Confirm whether you need entire columns, filtered subsets, or distinct values.
Use [COUNTIFS](/functions/countifs/) and [SUMIFS](/functions/sumifs/) for multi-criteria metrics.
Pivot tables complement single-cell statistical formulas for exploration.

Common errors

Returns 0 if no seasonality detected

Use cases

Pattern detection
Seasonal analysis
Forecasting setup

Frequently asked questions

What is the FORECAST.ETS.SEASONALITY function in Excel? FORECAST.ETS.SEASONALITY returns the length of the repetitive pattern Excel detects for the specified time series. The syntax is =FORECAST.ETS.SEASONALITY(values, timeline, [data_completion], [aggregation]). Typical use cases include pattern detection, seasonal analysis, forecasting setup.
How do I use the FORECAST.ETS.SEASONALITY function? To use FORECAST.ETS.SEASONALITY, type =FORECAST.ETS.SEASONALITY( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.
What type of data does FORECAST.ETS.SEASONALITY work with? FORECAST.ETS.SEASONALITY works with numerical data and can handle ranges, arrays, and individual values. It ignores text values and empty cells in its calculations, focusing only on numeric data for accurate statistical analysis.
Why is FORECAST.ETS.SEASONALITY not working in my Excel? Common issues with FORECAST.ETS.SEASONALITY include Returns 0 if no seasonality detected. Start by checking the syntax =FORECAST.ETS.SEASONALITY(values, timeline, [data_completion], [aggregation]), then verify each referenced cell or range.

Editorial review

Reviewed by Excel.Directory Editorial Team. Updated May 2026.