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