DATESFROM
Description
Returns an array of dates that starts on a particular date and continues for the
number of dates you specify, with a step interval between each date.
Syntax
DATESFROM(
start_date
,
num_dates
, [
step
])
- start_date: The starting date of the range.
- num_dates: The number of dates to be returned.
- step: The number of days to step between each date. The default is 1.
Example
Formula | Result |
|---|---|
=DATESFROM("01-Jan-2015", 4, 2) | { "1/1/2015"; "1/3/2015"; "1/5/2015"; "1/7/2015" } |
=DATESFROM("14-Jul-2016", 3, -1) | { "7/14/2016"; "7/13/2016"; "7/12/2016" } |
Notes
- This function returns a column ofnum_datesdates.
- This function is intended for use in array formulas.