Looking to making a column of dates… spanning a month… in ascending order
(Reconsider the tags, please. Only calc, probably also dates seem appropriate to me.)
Yo may already know, but…
Many issues leading to questions of the kind are related to the misissing distinction between texts claiming to give a date and numbers internally used to represent dates regarding spreadsheet standards, an just formatted in one or another way for the display.
Spredsheet dates are sorted without any problemss using >Data>Sort... independent of the used format.
If your dates actually are texts, you need to be much more specific. There is not a single and simple way to sort textual dates regarding any local customs unknown to us.
Hello,
(assuming cell A1 is the starting cell and month should be July 2020)
- Type
2020-07-01into cellA1 - Type
=A1+1into cellA2 - Select cell
A2and drag down (using the square at the lower right corner of the cell) to row 31 - Select column
A(or rangeA1:A31andFormat -> Cells(or `CTRL+1) and select your preferred date format
Hope that helps.
Unnecessary use formula cells, unless the starting date should be a modifiable input field.
- type your starting date into a cell, e.g. A1
2020-07-01 - select a cell range on which to enter the date series, either by mouse or focus the Name Box with Shift+Ctrl+T and enter the cell range, e.g.
A1:A99and hit Enter - menu Sheet → Fill Cells… → Fill Series…, Direction Down (preselected), Series Type Date (preselected), Time Unit Month
- (Start value should automatically be the 2020-07-01 already entered in A1, End value empty (will be determined), Increment 1 (1 month))
- hit OK button
Alternatively
- enter
2020-07-01into A1 - enter
2020-08-01into A2 - select cells A1:A2
- with the mouse pull down the handle at the selection’s bottom right corner (mouse pointer changes to cross) until you have enough data
Not sure if “spanning a month” meant a month interval (assumed) or each day in one month. If the latter then modify for days instead of months.