Script:

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

Note: for the function periods(s,e,i), s represents the start date, e represents the end date, and i represents the time interval. The default unit for time interval is day. The option @m means the time interval unit is month, @y means year, @q means quarter, @t means ten days, and @s means second.

esProc Desktop and Excel Processing
16.2 Calculate time repeat interval
16.4 Generate a time sequence with the same time interval – two days