How to add a column of consecutive dates in Numbers
Can I put a column with consecutive dates running down in Numbers? I'm running OS 15.7.7 Thanks for any help provided. 👍😃👍
Mac mini, macOS 15.7
Question marked as
Sure. There are several ways of doing this, depending on quite what you need.
The easiest method is to just enter the first date in the top cell, then select the cell and drag the little yellow handle down. This will incremement the dates to fill the range you select.
A second method would be to use SEQUENCE() to build an array of dates.
In the top of the column, enter the formula:
=SEQUENCE(20,1,"1/1/2026",1)
This will create a sequence of 20 consecutive dates starting on 1/1/2026. You can adjust the number of rows, start date, etc. to match your needs.
Do either of those work?