16.4 Generate a time sequence with the same time interval – two days

 

Script:

=spl("=periods(date(""2020-01-01"",""yyyy-MM-dd""),date(""2020-01-10"",""yyyy-MM-dd""),2)")

Note: when the third parameter of periods is set to 2, it means two interval units.

2020-01-01
2020-01-03
2020-01-05
2020-01-07
2020-01-09
2020-01-10

https://c.scudata.com/article/1651916536524
https://c.scudata.com/article/1659406546685
https://c.scudata.com/article/1659494204099