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

The syntax for FORECAST.ETS.CONFINT is: =FORECAST.ETS.CONFINT(target_date, values, timeline, [confidence_level], [seasonality], [data_completion], [aggregation])

What are common errors with FORECAST.ETS.CONFINT?

Confidence level must be between 0 and 1

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

To use FORECAST.ETS.CONFINT, type =FORECAST.ETS.CONFINT( 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.CONFINT work with?

FORECAST.ETS.CONFINT 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.CONFINT not working in my Excel?

Common issues with FORECAST.ETS.CONFINT include Confidence level must be between 0 and 1. Start by checking the syntax =FORECAST.ETS.CONFINT(target_date, values, timeline, [confidence_level], [seasonality], [data_completion], [aggregation]), then verify each referenced cell or range.

Statistical

FORECAST.ETS.CONFINT Function in Excel

Returns a confidence interval for the forecast value at the specified target date.

Syntax

=FORECAST.ETS.CONFINT(target_date, values, timeline, [confidence_level], [seasonality], [data_completion], [aggregation])

Arguments

target_date (required): Date to forecast
values (required): Historical values
timeline (required): Historical dates
confidence_level (optional): Confidence level (default 0.95)
seasonality (optional): Season length
data_completion (optional): Handle missing data
aggregation (optional): Aggregation method

Examples

=FORECAST.ETS.CONFINT(DATE(2025,1,1), B2:B25, A2:A25, 0.95) - 95% confidence interval - Result: Interval width

FORECAST.ETS.CONFINT 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

Confidence level must be between 0 and 1

Use cases

Forecast uncertainty
Risk analysis
Planning ranges

Frequently asked questions

What is the FORECAST.ETS.CONFINT function in Excel? FORECAST.ETS.CONFINT returns a confidence interval for the forecast value at the specified target date. The syntax is =FORECAST.ETS.CONFINT(target_date, values, timeline, [confidence_level], [seasonality], [data_completion], [aggregation]). Typical use cases include forecast uncertainty, risk analysis, planning ranges.
How do I use the FORECAST.ETS.CONFINT function? To use FORECAST.ETS.CONFINT, type =FORECAST.ETS.CONFINT( 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.CONFINT work with? FORECAST.ETS.CONFINT 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.CONFINT not working in my Excel? Common issues with FORECAST.ETS.CONFINT include Confidence level must be between 0 and 1. Start by checking the syntax =FORECAST.ETS.CONFINT(target_date, values, timeline, [confidence_level], [seasonality], [data_completion], [aggregation]), then verify each referenced cell or range.

Editorial review

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