Dynamic arrays › SEQUENCE101 / 144

Progress is saved on this device. Sign in or sign up free to keep it in your account.

EasyFreeSEQUENCE

SEQUENCE: weekly lesson schedule

Rani runs private English lessons every Saturday in Depok. For an 8-session package, she wants a schedule with the session number and its date that adjusts as soon as the start date in B1 changes.

Task

Write two SEQUENCE formulas:

A4: session numbers 1 to 8 (spilling into A4:A11).
B4: the dates of the 8 sessions, starting from the date in B1 and moving 7 days each session (spilling into B4:B11).

Cells to fillA4:A11B4:B11

Required functionsSEQUENCE

Expected result

Loading the expected result…

Check answerCtrlShiftEnter
Fill downCtrlD
Previous / next exerciseAlt←→
Leave the workspaceEscTab

Hint 1
SEQUENCE(rows, [columns], [start], [step]) builds a series of numbers. With only the row count, it starts at 1 and steps by 1.
Hint 2
Excel dates are really serial numbers, so a series of dates can also come from SEQUENCE: start = B1, step = 7.
Hint 3
For B4: =SEQUENCE(8, 1, …, …). Column B is already formatted as dates.

Reveal them one at a time. The last hint nearly gives the answer away.

Give it a try first. The solution unlocks automatically after your first check.

Answer

A4

=SEQUENCE(8)

B4

=SEQUENCE(8,1,B1,7)

Explanation

=SEQUENCE(8) returns 1 to 8, while =SEQUENCE(8,1,B1,7) returns 8 rows and 1 column, starting from the date in B1 and adding 7 each row. Since dates are stored as serial numbers, adding 7 moves one week ahead, so every date stays on a Saturday. Change the start date and the whole schedule shifts. Tip: keep the number of sessions in a cell and use that cell as the first argument.

Starting worksheet: Sheet1
Row	A	B
1	Start date	04/07/2026
2
3	Session no.	Date
4
5
6
7
8
9
10
11
12
13
14

Fill in the requested cells, then press Check answer.

Validation result