dates not sorting correctly

**Winoc** · 11-29-2018, 05:10 PM

Hi everyone,

For my credit handling at work I've made a sort of dashboard, which unfortunately I may not share (company policy). A lot of data is stored with certain dates. When sorting by date, it never sorts chronologically, ex:

15/11/18
15/11/18
09/11/18
17/11/18
17/11/18
...

All cells are marked as 'date' so I don't really understand the issue...
Is it possible that it 'reads' differently because several colleagues use this sheet on their PC?

Thanks for your help!

Winoc

**Fluff13** · 11-29-2018, 05:20 PM

I suspect that some of those dates are actually text.
Select the column & change the format to "General", do you still get cells that look like dates or is everything like 43433 or similar numbers?

**shg** · 11-29-2018, 05:21 PM

Your dates are stored as text.

Select the column, Data > Text to columns, Next, Next, Date: DMY, Finish.

**andrewjahns** · 11-29-2018, 06:31 PM

Definitely check to verify if they are text. I spent hours once with this same issue.

**AliGW** · 11-30-2018, 01:29 AM

Andrewjahns - please be aware that I am watching you. You have posted five times to different threads with nothing of any use or interest to add in any case. If you have a question, start your own thread, please.

**Winoc** · 07-23-2019, 08:36 AM

in the end it seemed to be a combination of date-as-text and different computers who didn't have the same language setting, resulting in issues within my formulas...