Module: Editor
Version: 20.09 +
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.