Sort

[rival36]

I am unable to sort dates from newest to oldest in this sheet. I don't want to change the date format. It should be like 01-Feb-2022 . Please help
mini sheet attached

New Microsoft Excel Worksheet (2).xlsx
	A	B	C
1
2		DATE1
3		01-Feb-2022
4		01-Apr-2022
5		01-Jun-2022
6		01-Jul-2022
7		01-Aug-2022
8		01-Sep-2021
9		01-Sep-2022
10		01-Oct-2021
11		01-Nov-2021
12		01-Nov-2022
13		01-Dec-2021
14		01-Dec-2022
15		02-Jan-2023
16		02-Feb-2022
17		02-Mar-2022
18		02-May-2022
19		02-Jun-2022
20		02-Aug-2021
21		02-Aug-2022
22		02-Sep-2021
23		02-Sep-2022
24		02-Nov-2021
25		02-Nov-2022
26
27
Sheet1

 

[Fluff]

If those "dates" are in-fact text, then you will need to use a helper column. Do you use an English language version of Excel?

 

[rival36]

If those "dates" are in-fact text, then you will need to use a helper column. Do you use an English language version of Excel?

Yes sir

 

[Kerryx]

Just select column and use "text to column" in step 3 select Date and leave at DMY, Finish. Then select your sort option , it should do the job

 

[Fluff]

Ok, for the helper column you can use this

Fluff.xlsm
	A	B	C
1
2		DATE1	Helper
3		01-Feb-2022	01/02/2022
4		01-Apr-2022	01/04/2022
5		01-Jun-2022	01/06/2022
6		01-Jul-2022	01/07/2022
7		01-Aug-2022	01/08/2022
8		01-Sep-2021	01/09/2021
9		01-Sep-2022	01/09/2022
10		01-Oct-2021	01/10/2021
11		01-Nov-2021	01/11/2021
12		01-Nov-2022	01/11/2022
13		01-Dec-2021	01/12/2021
14		01-Dec-2022	01/12/2022
15		02-Jan-2023	02/01/2023
16		02-Feb-2022	02/02/2022
17		02-Mar-2022	02/03/2022
18		02-May-2022	02/05/2022
19		02-Jun-2022	02/06/2022
20		02-Aug-2021	02/08/2021
21		02-Aug-2022	02/08/2022
22		02-Sep-2021	02/09/2021
23		02-Sep-2022	02/09/2022
24		02-Nov-2021	02/11/2021
25		02-Nov-2022	02/11/2022
Data

Cell Formulas
Range	Formula
C3:C25	C3	=DATEVALUE(B3)

And then sort on col C

 

[rival36]

Yes that works। Text to column not worked। Thanks

 

[Fluff]

Glad we could help & thanks for the feedback.