Google Sheets Array Generation

Question

Is it possible to generate an array of numbers between two provided numbers eg =sequence(1,10) results in {1,2,3,4,5,6,7,8,9,10}

My end goals is to generate a list of days between two dates, but have tried to generalise the question.

I thought about using =TREND, but I couldn't figure it out.

Answer 1

=arrayformula(row(1:10))

returns a list of numbers 1 through 10, as a column. Can be made a row with transpose.

A dynamic version, where the upper bound is taken from cell C1:

=arrayformula(row(indirect("1:" & C1)))

Answer 2

You can also do same using DATE function, this gives you ability to generate months or years.

Pretending start date is written in A2 and end date is written in B2. This formula will generate a list of dates between (inluding start, excluding end).

=ARRAYFORMULA(DATE(YEAR(A2), MONTH(A2), DAY(A2) + SEQUENCE(DATEDIF(A2,B2,"D"), 1, 0, 1)))

Few explanations:

DATE function has ability to move over month if days is over last day of that month of that year. Same goes for months.

DATEDIF(A2,B2,"D") gives you amount of days between the dates. You can + 1 if you want to include end date.

SEQUENCE(DATEDIF(A2,B2,"D"), 1, 0, 1) generates number from 0 to amount of days generated above.