SEQUENCE

SEQUENCE(rows [,columns] [,start] [,step])

Returns the array of sequential numbers.

rows	The number of rows to return.
columns	(Optional) The number of columns to return.
start	(Optional) The first number in the sequence.
step	(Optional) The amount to increment each subsequent value in the array.

REMARKS

* This function was added in Excel 2021.
* This function can create a Dynamic Array Formula.
* If "columns" is left blank, then 1 is used.
* If "start" is left blank, then 1 is used.
* If "step" is left blank, then 1 is used.
* You can use the WORKDAY.INTL function to returns the date serial number that is a given number of working days before or after a date.
* For the Microsoft documentation refer to support.microsoft.com

	A
1	=SEQUENCE(1) = 1
2	=SEQUENCE(2) = { 1, 2 }
3	=SEQUENCE(4) = { 1, 2, 3, 4 }
4	=SEQUENCE(1,2) = { 1, 2 }
5	=SEQUENCE(2,2) = { 1, 2; 3, 4 }
6	=WORKDAY.INTL("5 Jan 2022", SEQUENCE(4)) = { 44567, 44568, 44571, 44572 }

1 - Return a sequence of numbers for an array of 1 row and 1 column.
2 - Return the next 2 numbers in a column.
3 - Return the next 4 numbers in a column.
4 - Return a sequence of numbers for an array of 1 row and 2 columns
5 - Return a sequence of numbers for an array of 2 rows and 2 columns
6 - Return the next 4 workdays after "5 Jan 2022".