Spreadsheet: 739831d1625991220-filter-formula-to-show-transactions-in-chronlogical-date-order-filter-formula-in-order-of-dates
Sheet: Sales by Region

I'm kindly asking for the adjustment of Filter formula to show the transactions in chronological order of dates. The current formula is working well but the transactions are not in date order form.
 |  | SALES BY REGION
 |  | Month | JANUARY | Drop down list |  |  |  |  |  | January
 |  |  |  |  |  |  |  |  |  | February
City | Date | Name | Reference | Southern Region | Northern Region |  |  |  |  | March
 | 2021-01-11 00:00:00 | ANDILE B | 14230 | 11500 | 0 |  |  |  |  | April
BULAWAYO | 2021-01-13 00:00:00 | ANDREY | 14231 | 20000 | 0 |  |  |  |  | May
BULAWAYO | 2021-01-21 00:00:00 | [NAME] | 14232 | 2572 | 0 |  |  |  |  | June
BULAWAYO | 2021-01-28 00:00:00 | Faith | 14233 | 22572.9 | 0 |  |  |  |  | July
BULAWAYO | 2021-01-28 00:00:00 | [NAME] | 14234 | 5180 | 0 |  |  |  |  | August
BULAWAYO | 2021-01-29 00:00:00 | Amal | 14235 | 6567.7 | 0 |  |  |  |  | September
BULAWAYO | 2021-01-30 00:00:00 | ANDILE B | 14236 | 5000 | 0 |  |  |  |  | October
BULAWAYO | 2021-01-04 00:00:00 | [NAME] | 1 | 0 | 5890 |  |  |  |  | November
BULAWAYO | 2021-01-05 00:00:00 | Faith | 2 | 0 | 1400 |  |  |  |  | December
BULAWAYO | 2021-01-05 00:00:00 | [NAME] | 3 | 0 | 1400
BULAWAYO | 2021-01-05 00:00:00 | Amal | 4 | 0 | 1400
BULAWAYO | 2021-01-05 00:00:00 | ANDILE B | 5 | 0 | 1400
BULAWAYO | 2021-01-05 00:00:00 | ANDREY | 6 | 0 | 1400
BULAWAYO | 2021-01-05 00:00:00 | [NAME] | 7 | 0 | 1400
BULAWAYO | 2021-01-05 00:00:00 | Faith | 8 | 0 | 1400
BULAWAYO | 2021-01-05 00:00:00 | [NAME] | 9 | 0 | 1400
BULAWAYO | 2021-01-05 00:00:00 | Amal | 10 | 0 | 1400
BULAWAYO | 2021-01-05 00:00:00 | ANDILE B | 11 | 0 | 1400
BULAWAYO | 2021-01-05 00:00:00 | ANDREY | 12 | 0 | 1400
BULAWAYO | 2021-01-05 00:00:00 | [NAME] | 13 | 0 | 1400
BULAWAYO | 2021-01-07 00:00:00 | Faith | 14 | 0 | 20000
BULAWAYO | 2021-01-09 00:00:00 | [NAME] | 15 | 0 | 1920
BULAWAYO | 2021-01-26 00:00:00 | Amal | 16 | 0 | 6581
BULAWAYO | 2021-01-26 00:00:00 | ANDILE B | 17 | 0 | 5793
BULAWAYO | 2021-01-26 00:00:00 | ANDREY | 18 | 0 | 4461
BULAWAYO | 2021-01-26 00:00:00 | [NAME] | 19 | 0 | 7913
BULAWAYO | 2021-01-26 00:00:00 | Faith | 20 | 0 | 4953
BULAWAYO | 2021-01-26 00:00:00 | [NAME] | 21 | 0 | 4043
BULAWAYO | 2021-01-26 00:00:00 | Amal | 22 | 0 | 4584
BULAWAYO | 2021-01-26 00:00:00 | ANDILE B | 23 | 0 | 11043
BULAWAYO | 2021-01-26 00:00:00 | ANDREY | 24 | 0 | 3399
BULAWAYO | 2021-01-26 00:00:00 | [NAME] | 25 | 0 | 4580
BULAWAYO | 2021-01-26 00:00:00 | Faith | 26 | 0 | 11134
BULAWAYO | 2021-01-26 00:00:00 | [NAME] | 27 | 0 | 4107
BULAWAYO | 2021-01-26 00:00:00 | Amal | 28 | 0 | 4359
BULAWAYO | 2021-01-26 00:00:00 | ANDILE B | 29 | 0 | 7929
BULAWAYO | 2021-01-26 00:00:00 | ANDREY | 30 | 0 | 10480
BULAWAYO | 2021-01-26 00:00:00 | [NAME] | 31 | 0 | 9370
BULAWAYO | 2021-01-26 00:00:00 | Faith | 32 | 0 | 9222
BULAWAYO | 2021-01-26 00:00:00 | [NAME] | 33 | 0 | 5360
BULAWAYO | 2021-01-26 00:00:00 | Amal | 34 | 0 | 2540
BULAWAYO | 2021-01-26 00:00:00 | ANDILE B | 35 | 0 | 5883
BULAWAYO | 2021-01-26 00:00:00 | ANDREY | 36 | 0 | 8637
BULAWAYO | 2021-01-26 00:00:00 | [NAME] | 37 | 0 | 9296
BULAWAYO | 2021-01-26 00:00:00 | Faith | 38 | 0 | 9272
BULAWAYO | 2021-01-26 00:00:00 | [NAME] | 39 | 0 | 2195
BULAWAYO | 2021-01-26 00:00:00 | Amal | 40 | 0 | 4000
BULAWAYO | 2021-01-26 00:00:00 | ANDILE B | 41 | 0 | 528.54
BULAWAYO | 2021-01-31 00:00:00 | ANDREY | 42 | 0 | 21383.03
BULAWAYO | 2021-01-04 00:00:00 | ANDILE B | 110 | 0 | 765
BULAWAYO | 2021-01-04 00:00:00 | ANDREY | 111 | 0 | 11900
BULAWAYO | 2021-01-04 00:00:00 | [NAME] | 112 | 0 | 935
BULAWAYO | 2021-01-04 00:00:00 | Faith | 113 | 0 | 8500
BULAWAYO | 2021-01-04 00:00:00 | [NAME] | 114 | 0 | 20400
BULAWAYO | 2021-01-04 00:00:00 | Amal | 115 | 0 | 24369.5
BULAWAYO | 2021-01-04 00:00:00 | ANDILE B | 116 | 0 | 24750
BULAWAYO | 2021-01-27 00:00:00 | ANDREY | 117 | 0 | 255
BULAWAYO | 2021-01-27 00:00:00 | [NAME] | 118 | 0 | 2975
BULAWAYO | 2021-01-27 00:00:00 | Faith | 119 | 0 | 484.5
BULAWAYO | 2021-01-04 00:00:00 | [NAME] | 126 | 0 | 2006