I would like to know a quick way to fill a column with consecutive dates
For ascending dates enter the first date in cell, for example in A1, select the cell A1, click on the small black square at the bottom right of the cell cursor and drag it further down the column.
For descending dates enter the last date in A1, Then in cell A2 enter the formula =A1 - 1, then copy or drag that formula further down the column.
Above will use default date format, use menu Format, Cells and on the Numbers tab select your preferred date format.
In a cell enter start date from which to decrement, select/mark cell range to fill (including the start date), menu Sheet → Fill Cells → Series… from Time Unit select Day, in Increment enter -1, OK.
Thank you! This was simple enough for me to follow and easily solved my issue. Thank you so much!