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
Arguments
fromDate- The start of the date range. Required.
toDate- The end date of the range. Required.
Return value
Array of dates
Example
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
Last updated
Was this helpful?