Exercises / Modern Excel: dynamic arrays · 12 of 12
A 12-month timeline in one formula
SEQUENCE(rows, [columns], [start], [step]) returns a list of numbers. Feed it to a date function and you get a whole timeline: EOMONTH(start, SEQUENCE(12,1,0)) gives twelve month-ends, the backbone of a monthly model.
Your taskIn A4, use EOMONTH and SEQUENCE to return the last day of each of the 12 months starting with the month of the date in B1.
Pro
Unlock this exercise and every module after the basics.
Pro opens every exercise in every module, your review schedule, and the final test for the course certificate.
| Row | A | B |
|---|---|---|
| 1 | Model start | 10 Jan 2027 |
| 2 | ||
| 3 | Month end | Revenue |