Fill a large range of cells with sequential dates

[caliray]

The examples I’ve seen indicate that using sheet—>fill should open a dialog box for me to enter a start date, end date and increment value.

If I enter a date value in a cell and select a range of cells, all I can do is fill the range with the same date.

No dialog box ever opens.

I could enter a start date and drag down, but this would take quite a while to fill 53,600 rows when I should be able to do this automatically.

[Zizi64]

How you entered the dates?

Try to use the ISO date format. Then the entered date like strings will be recognized as numeric values (as the real dates are numeric values)

[Zizi64]

• Fill in the first cell in the column with the start date. Use the ISO format: like 2022-12-28 .
• Then select the first two cells in the column.
• Edit the cell reference in the Name Box modify the last cell reference to the desired value. Hit ENTER. The desired cell range will be selected.
• Sheet - Fill Cells - Series
• Check the appeared Start value, modify it if it is necessary, enter the End value, and modify the Increment value if it is necessary.
• Direction: Down; Series type: Date; Time unit: Day
• Click on the OK.

[caliray]

Thanks for your suggestion.

I see the problem now. Calc will not open the fill series dialog box until the range to fill has been selected.

[mikekaganski]

[caliray]

Thanks for the screen recording.