PERIOD_RANGE

The PERIOD_RANGE function returns an array of date ranges between two specified dates. It can be used with other functions like FILTER.

Syntax

PERIOD_RANGE(fromDate, toDate)

Arguments

fromDate- The start of the date range. Required.

toDate- The end date of the range. Required.

Return value

Array of dates

Example

PERIOD_RANGE(DATE(2023,1,1),DATE(2023, 12,31))
//Create a date range for 2023

The PERIOD_RANGE function can be used with forecasts as well. In this application of the PERIOD_RANGE function

• The PERIOD_RANGE function is used to select the open forecast periods

• The FILTER function filters out the forecast values > 1000 for open periods

• The open forecasts greater than 1000 are then summed up

PERIOD_RANGE function used with forecasts