Search

 

Module: Editor

Version: 20.09 +

Type: Long, Double or Date

Category: Matrix

 

Description

The formula 'Range' replaces the previous Range object. It returns a range of integers, doubles or dates.

Parameters

From:                 the start point of the range. Either a long, double or date (according to the Type of the formula)

To:                     the end point of the range. Either a long, double or date (according to the Type of the formula)

Step:                 the step size of the range (only for Type long and double)

Step (days):      the step size in days (only for Type date)

Step (months):  the step size in months (only for Type date)

Step (years):     the step size in years (only for Type date)

Example

Description

In the following example the formula 'Range' is used to get a sequence of dates.

Values parameters

From:             1-1-2020

To:                 1-4-2025

Step (days):     0

Step (months): 0

Step (years):    1

Result

1-1-2020
1-1-2021
1-1-2022
1-1-2023
1-1-2024
1-1-2025

Related Topics

Range: the former Range object that is replaced by these formulas.

 - Step: Formula that creates a sequence of integers.

Feedback

If you have any questions about this subject or if you want to provide us feedback please send us an e-mail.

Updated: 2020-10-07