Ask Your Question

How to make a column of dates in acending order

asked 2020-06-26 21:36:44 +0200

BernB gravatar image

Looking to making a column of dates.. spanning a month.. in ascending order

edit retag flag offensive close merge delete


(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.

Lupp gravatar imageLupp ( 2020-06-26 21:46:27 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2020-06-27 12:37:28 +0200

Opaque gravatar image


(assuming cell A1 is the starting cell and month should be July 2020)

  • Type 2020-07-01 into cell A1
  • Type =A1+1 into cell A2
  • Select cell A2 and drag down (using the square at the lower right corner of the cell) to row 31
  • Select column A (or range A1:A31 and Format -> Cells (or `CTRL+1) and select your preferred date format

Hope that helps.

edit flag offensive delete link more


Unnecessary use formula cells, unless the starting date should be a modifiable input field.

erAck gravatar imageerAck ( 2020-06-27 18:03:17 +0200 )edit

answered 2020-06-27 17:59:38 +0200

erAck gravatar image
  1. type your starting date into a cell, e.g. A1 2020-07-01
  2. 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:A99 and hit Enter
  3. menu Sheet -> Fill Cells... -> Fill Series..., Direction Down (preselected), Series Type Date (preselected), Time Unit Month
  4. (Start value should automatically be the 2020-07-01 already entered in A1, End value empty (will be determined), Increment 1 (1 month))
  5. hit OK button


  1. enter 2020-07-01 into A1
  2. enter 2020-08-01 into A2
  3. select cells A1:A2
  4. with the mouse pull down the handle at the selection's bottom right corner (mouse pointer changes to cross) until you have enough data
edit flag offensive delete link more


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.

erAck gravatar imageerAck ( 2020-06-27 18:01:43 +0200 )edit
Login/Signup to Answer

Question Tools

1 follower


Asked: 2020-06-26 21:36:44 +0200

Seen: 32 times

Last updated: Jun 27