EXPAND_DATE_RANGE

Syntax

EXPAND_DATE_RANGE(<range_start:date>;<range_end:date>[;<interval:integer> or time interval])

Description

Expands a date range into multiple rows, one for each interval, one day by default. The generated series of dates starts with the range_start parameter and end with the range_end parameter (if applicable) and the series is sorted based on the relationship between these parameters: 

If range_start is before range_end, the series runs forward in time from range_start.

If range_start is after range_end, the series runs backwards in time from range_start.

The interval parameter defaults to one day and can be changed in the field using an integer set in milliseconds (ms) or a time interval (10d, 1h, 30s, etc.)

Example

Given the following data:

Then use the function EXPAND_DATE_RANGE(#Workbook!Date_1;#Workbook!Date_2)

The result of the function is: