Excel's SEQUENCE function lets you create a list of numbers in a sequence in an instant. It also allows you to define the shape, number of values, and steps between each number in the sequence ...

How to return a sequence of dates in Excel Excel’s fill handle can generate a quick list of dates for you, but the list is static; you must create a new list if your needs change.

This is because SEQUENCE is a dynamic array function that produces a spilled array, and Excel tables aren't compatible with results generated in this way.

Learn how to how to increment numbers when value changes in another column. You can automatically fill increment cells in Excel such that the increment value across each cell remains constant.