Spreadsheet: 739832d1625991932-filter-formula-to-show-transactions-in-chronlogical-date-order-filter-formula-in-order-of-dates-aligw
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-02-26 00:00:00 | ANDREY | 81 | 0 | 250 |  |  |  |  | April
BULAWAYO | 2021-02-26 00:00:00 | [NAME] | 82 | 0 | 1607 |  |  |  |  | May
BULAWAYO | 2021-02-26 00:00:00 | Faith | 83 | 0 | 250 |  |  |  |  | June
BULAWAYO | 2021-02-26 00:00:00 | [NAME] | 84 | 0 | 4816 |  |  |  |  | July
BULAWAYO | 2021-02-26 00:00:00 | Amal | 85 | 0 | 250 |  |  |  |  | August
BULAWAYO | 2021-02-26 00:00:00 | ANDILE B | 86 | 0 | 4681 |  |  |  |  | September
BULAWAYO | 2021-02-26 00:00:00 | ANDREY | 87 | 0 | 250 |  |  |  |  | October
BULAWAYO | 2021-03-25 00:00:00 | Amal | 52 | 0 | 5862.21 |  |  |  |  | November
BULAWAYO | 2021-03-25 00:00:00 | ANDILE B | 53 | 0 | 250 |  |  |  |  | December
BULAWAYO | 2021-03-25 00:00:00 | ANDREY | 54 | 0 | 8851.26
BULAWAYO | 2021-03-25 00:00:00 | [NAME] | 55 | 0 | 250
BULAWAYO | 2021-03-25 00:00:00 | Faith | 56 | 0 | 9840.68
BULAWAYO | 2021-03-25 00:00:00 | [NAME] | 57 | 0 | 250
BULAWAYO | 2021-03-25 00:00:00 | Amal | 58 | 0 | 8576.61
BULAWAYO | 2021-03-25 00:00:00 | ANDILE B | 59 | 0 | 250
BULAWAYO | 2021-03-25 00:00:00 | ANDREY | 60 | 0 | 9723.04
BULAWAYO | 2021-03-25 00:00:00 | [NAME] | 61 | 0 | 250
BULAWAYO | 2021-03-25 00:00:00 | Faith | 62 | 0 | 9231.65
BULAWAYO | 2021-03-25 00:00:00 | [NAME] | 63 | 0 | 250
BULAWAYO | 2021-03-25 00:00:00 | Amal | 64 | 0 | 9272.56
BULAWAYO | 2021-03-25 00:00:00 | ANDILE B | 65 | 0 | 250
BULAWAYO | 2021-03-25 00:00:00 | ANDREY | 66 | 0 | 7840.89
BULAWAYO | 2021-03-25 00:00:00 | [NAME] | 67 | 0 | 250
BULAWAYO | 2021-03-25 00:00:00 | Faith | 68 | 0 | 9222.56
BULAWAYO | 2021-03-25 00:00:00 | [NAME] | 69 | 0 | 250
BULAWAYO | 2021-03-25 00:00:00 | Amal | 70 | 0 | 5754.39
BULAWAYO | 2021-03-25 00:00:00 | ANDILE B | 71 | 0 | 250
BULAWAYO | 2021-03-25 00:00:00 | ANDREY | 72 | 0 | 4042.65
BULAWAYO | 2021-03-25 00:00:00 | [NAME] | 73 | 0 | 250
BULAWAYO | 2021-03-25 00:00:00 | Faith | 74 | 0 | 4567.17
BULAWAYO | 2021-03-25 00:00:00 | [NAME] | 75 | 0 | 250
BULAWAYO | 2021-03-25 00:00:00 | Amal | 76 | 0 | 4366.95
BULAWAYO | 2021-03-25 00:00:00 | ANDILE B | 77 | 0 | 250
BULAWAYO | 2021-03-25 00:00:00 | ANDREY | 78 | 0 | 4359
BULAWAYO | 2021-03-25 00:00:00 | [NAME] | 79 | 0 | 250
BULAWAYO | 2021-03-25 00:00:00 | Faith | 80 | 0 | 4888.65
BULAWAYO | 2021-03-25 00:00:00 | [NAME] | 81 | 0 | 250
BULAWAYO | 2021-03-25 00:00:00 | Amal | 82 | 0 | 4549.31
BULAWAYO | 2021-03-25 00:00:00 | ANDILE B | 83 | 0 | 250
BULAWAYO | 2021-03-25 00:00:00 | ANDREY | 84 | 0 | 6482.99
BULAWAYO | 2021-03-25 00:00:00 | [NAME] | 85 | 0 | 250
BULAWAYO | 2021-03-25 00:00:00 | Faith | 86 | 0 | 4043.16
BULAWAYO | 2021-03-25 00:00:00 | [NAME] | 87 | 0 | 250
BULAWAYO | 2021-03-25 00:00:00 | Amal | 88 | 0 | 8971.64
BULAWAYO | 2021-03-25 00:00:00 | ANDILE B | 89 | 0 | 250
BULAWAYO | 2021-03-25 00:00:00 | ANDREY | 90 | 0 | 7868.45
BULAWAYO | 2021-03-25 00:00:00 | [NAME] | 91 | 0 | 250
US$ | 2021-03-25 00:00:00 | ANDILE B | 149 | 0 | 1700
US$ | 2021-03-26 00:00:00 | ANDREY | 13302 | 14875 | 0
BULAWAYO | 2021-04-09 00:00:00 | ANDILE B | 3a | 600 | 0
0 | 2021-04-09 00:00:00 | [NAME] | 7a | 0 | 0
BULAWAYO | 2021-04-09 00:00:00 | Amal | 158 | 0 | 20
BULAWAYO | 2021-04-09 00:00:00 | ANDILE B | 157 | 0 | 28935.36
US$ | 2021-04-09 00:00:00 | ANDREY | 500 | 0 | 4250
US$ | 2021-04-09 00:00:00 | Faith | 508 | 0 | 5701.8
US$ | 2021-04-12 00:00:00 | Faith | 13310 | 8500 | 0
BULAWAYO | 2021-04-12 00:00:00 | Amal | 8a | 450 | 0
BULAWAYO | 2021-04-12 00:00:00 | ANDREY | 156 | 0 | 3188.96
BULAWAYO | 2021-04-12 00:00:00 | [NAME] | 155 | 0 | 63.78
BULAWAYO | 2021-04-13 00:00:00 | Amal | 14271 | 23375 | 0