Ask Your Question

Chronological date columns [closed]

asked 2016-09-21 16:51:15 +0100

LibreOfficeWorker gravatar image

updated 2020-08-02 12:55:23 +0100

Alex Kemp gravatar image

I want to have a date column that can filter row entries by date so that, for example, on a timesheet the most urgent project can be filtered to appear at the top of the sheet and the least pressing at the bottom. I presume the way to arrange the date is YY/MM/DD in that order, but I don't know how to set that up - advice welcomed, thanks.

edit retag flag offensive reopen merge delete

Closed for the following reason question is not relevant or outdated by Alex Kemp
close date 2020-07-22 08:00:21.977147

3 Answers

Sort by » oldest newest most voted

answered 2016-11-30 14:56:22 +0100

this post is marked as community wiki

This post is a wiki. Anyone with karma >75 is welcome to improve it.

I had great difficulty sorting columns by date.

Data - Sort - with a column with date values would only sort by digit order. So UK Irish date format of DD/MM/YYYY doesn't work.

Changing the date format Format - Cells - Date wouldn't work - the format remained the same. Eventually I created a new column, and entered


which converted 29/12/2009 in cell C513 to 20091229 in cell B513, but with the formula in each cell:- I then Pasted SPECIAL (first tried numbers - but that produced blank cell) Edit - Paste Special - Text This gave a text version of the original Date

which then sorted correctly.

Not necesary - but I created a new column with : =VALUE(B513) which gave a number from the text in B513

edit flag offensive delete link more


This only can happen when cells have text-dates no dates as they are used with the spreadsheets.

m.a.riosv gravatar imagem.a.riosv ( 2016-11-30 15:53:19 +0100 )edit

Thanks, this is the only answer that helped me. I would upvote but don't yet have the points to do so.

webilicious gravatar imagewebilicious ( 2020-07-25 10:18:17 +0100 )edit

answered 2016-09-21 17:01:20 +0100

mark_t gravatar image

Format the cells of the date column to any date format using the menu "Format", "Cells..." on the "Numbers" tab, and for category select "Date". You can choose whichever date format you prefer, they will all allow you to sort the column by ascending (earliest date) or descending (latest date).

edit flag offensive delete link more

answered 2016-11-30 22:52:11 +0100

m.a.riosv gravatar image

Convert a column with dates as text, the easy way is Menu/Data/Text to column, click on the head of the column and select the adecuate type column.

edit flag offensive delete link more

Question Tools

1 follower


Asked: 2016-09-21 16:51:15 +0100

Seen: 7,981 times

Last updated: Nov 30 '16