Spreadsheet: 871567d1718017856-filter-function-to-arrange-transactions-in-date-order-date-order
Sheet: ZIG Monthly transactions

 | The formula on B8, uses in information on the transactions sheet. The formula filters transactions well, however I want the formula to be adjusted to arrange the transactions in date order.
 | ZIG
 | Date | Bank | Name | I.D Number | Account | Account Number | Group Code | Group | Description | Invoice | Reference | ZWL VAT | USD VAT | [NAME] | [NAME] | USD Debit | USD Credit | Debit | Credits
 |  | ZIG | Customers Suspense Account | CT 001 | Fees | 2000 | C1 | Cash receipts from customers | 0 | 0 | 15860 | First Term | Customer | 0 | 1356 | 0 | 0 | 0 | 1356
 | 2024-04-29 00:00:00 | ZIG | 0 |  | Fees | 2000 | C1 | Cash receipts from customers | 0 | 0 | 15862 | First Term |  | 0 | 1350 | 0 | 0 | 0 | 1350
 | 2024-05-06 00:00:00 | ZIG | 0 | CT 129 | Fees | 2000 | C1 | Cash receipts from customers | 0 | 0 | 15863 | Second Term | Customer | 0 | 0 | 0 | 2133.34 | 0 | 32092.4096218
 | 2024-05-06 00:00:00 | ZIG | 0 | CT 128 | Fees | 2000 | C1 | Cash receipts from customers | 0 | 0 | 15863A | Second Term | Customer | 0 | 0 | 0 | 2133.33 | 0 | 32092.2591891
 | 2024-05-06 00:00:00 | ZIG | 0 | CT 135 | Fees | 2000 | C1 | Cash receipts from customers | 0 | 0 | 15863B | Second Term | Customer | 0 | 0 | 0 | 2133.33 | 0 | 32092.2591891
 | 2024-05-06 00:00:00 | ZIG | 0 | CT 407 | Fees | 2000 | C1 | Cash receipts from customers | 0 | 0 | 15864 | Second Term | Customer | 0 | 0 | 0 | 1485 | 0 | 22339.25595
 | 2024-05-16 00:00:00 | ZIG | 0 | CT 001 | Fees | 2000 | C1 | Cash receipts from customers | 0 | 0 | 15865 | Second Term | Customer | 0 | 1356 | 0 | 0 | 0 | 1356
 | 2024-05-30 00:00:00 | ZIG | 0 | CT 449 | Fees | 2000 | C1 | Cash receipts from customers | 0 | 0 | 15866 | Second Term | Customer | 0 | 1485 | 0 | 0 | 0 | 1485
 | 2024-05-31 00:00:00 | ZIG | 0 | CT 128 | Fees | 2000 | C1 | Cash receipts from customers | 0 | 0 | 15867 | Second Term | Customer | 0 | 2475 | 0 | 0 | 0 | 2475
 | 2024-05-31 00:00:00 | ZIG | 0 | CT 135 | Fees | 2000 | C1 | Cash receipts from customers | 0 | 0 | 15868 | Second Term | Customer | 0 | 2475 | 0 | 0 | 0 | 2475
 | 2024-05-31 00:00:00 | ZIG | 0 | CT 129 | Fees | 2000 | C1 | Cash receipts from customers | 0 | 0 | 15869 | Second Term | Customer | 0 | 2475 | 0 | 0 | 0 | 2475
 | 2024-05-02 00:00:00 | ZIG | 0 |  | Bank Charges | 3210 | P1 | Payment for general and administrative expenses | 0 | 0 | Mayb1 | Second Term |  | 120 | 0 | 0 | 0 | 120 | 0
 | 2024-05-02 00:00:00 | ZIG | 0 |  | Bank Charges | 3210 | P1 | Payment for general and administrative expenses | 0 | 0 | Mayb2 | Second Term |  | 16 | 0 | 0 | 0 | 16 | 0
 | 2024-05-09 00:00:00 | ZIG | 0 | ST 006 | PAYE | 2780 | P1 | Payment for general and administrative expenses | 0 | 0 | Mayb3 | Second Term | Sundry | 15.01 | 0 | 0 | 0 | 15.01 | 0
 | 2024-05-10 00:00:00 | ZIG | 0 |  | Electricity | 2660 | P1 | Payment for general and administrative expenses | 0 | 0 | 2274 | Second Term |  | 400 | 0 | 0 | 0 | 400 | 0
 | 2024-05-10 00:00:00 | ZIG | 0 |  | Electricity | 2660 | P1 | Payment for general and administrative expenses | 0 | 0 | 2275 | Second Term |  | 270 | 0 | 0 | 0 | 270 | 0
 | 2024-05-10 00:00:00 | ZIG | 0 |  | Bank Charges | 3210 | P1 | Payment for general and administrative expenses | 0 | 0 | Mayb4 | Second Term |  | 13.4 | 0 | 0 | 0 | 13.4 | 0
 | 2024-05-10 00:00:00 | ZIG | 0 |  | Bank Charges | 3210 | P1 | Payment for general and administrative expenses | 0 | 0 | [NAME] | Second Term |  | 6.7 | 0 | 0 | 0 | 6.7 | 0
 | 2024-05-21 00:00:00 | ZIG | 0 |  | Electricity | 2660 | P1 | Payment for general and administrative expenses | 0 | 0 | 2293 | Second Term |  | 668.4999999999999 | 0 | 0 | 0 | 668.4999999999999 | 0
 | 2024-05-21 00:00:00 | ZIG | 0 |  | Electricity | 2660 | P1 | Payment for general and administrative expenses | 0 | 0 | 2294 | Second Term |  | 401.1 | 0 | 0 | 0 | 401.1 | 0
 | 2024-05-21 00:00:00 | ZIG | 0 |  | Water | 2630 | P1 | Payment for general and administrative expenses | 0 | 0 | 2288 | Second Term |  | 700 | 0 | 0 | 0 | 700 | 0
 | 2024-05-21 00:00:00 | ZIG | 0 |  | Water | 2630 | P1 | Payment for general and administrative expenses | 0 | 0 | 2289 | Second Term |  | 700 | 0 | 0 | 0 | 700 | 0
 | 2024-05-21 00:00:00 | ZIG | 0 |  | Telephone & Internet | 2830 | P1 | Payment for general and administrative expenses | 0 | 0 | 2290 | Second Term |  | 483 | 0 | 0 | 0 | 483 | 0
 | 2024-05-21 00:00:00 | ZIG | 0 |  | Telephone & Internet | 2830 | P1 | Payment for general and administrative expenses | 0 | 0 | 2291 | Second Term |  | 262 | 0 | 0 | 0 | 262 | 0
 | 2024-05-21 00:00:00 | ZIG | 0 |  | Sundry Expenses | 2760 | P1 | Payment for general and administrative expenses | First Aid medicine | 0 | 2292 | Second Term |  | 140 | 0 | 0 | 0 | 140 | 0
 | 2024-05-21 00:00:00 | ZIG | 0 |  | Bank Charges | 3210 | P1 | Payment for general and administrative expenses | 0 | 0 | Mayb6 | Second Term |  | 67.09 | 0 | 0 | 0 | 67.09 | 0
 | 2024-05-21 00:00:00 | ZIG | 0 |  | Bank Charges | 3210 | P1 | Payment for general and administrative expenses | 0 | 0 | Mayb7 | Second Term |  | 10.7 | 0 | 0 | 0 | 10.7 | 0
 | 2024-05-21 00:00:00 | ZIG | 0 |  | Bank Charges | 3210 | P1 | Payment for general and administrative expenses | 0 | 0 | [NAME] | Second Term |  | 2.4 | 0 | 0 | 0 | 2.4 | 0
 | 2024-05-21 00:00:00 | ZIG | 0 |  | Bank Charges | 3210 | P1 | Payment for general and administrative expenses | 0 | 0 | Mayb9 | Second Term |  | 7 | 0 | 0 | 0 | 7 | 0
 | 2024-05-21 00:00:00 | ZIG | 0 |  | Bank Charges | 3210 | P1 | Payment for general and administrative expenses | 0 | 0 | Mayb10 | Second Term |  | 7 | 0 | 0 | 0 | 7 | 0
 | 2024-05-21 00:00:00 | ZIG | 0 |  | Bank Charges | 3210 | P1 | Payment for general and administrative expenses | 0 | 0 | Mayb11 | Second Term |  | 7.45 | 0 | 0 | 0 | 7.45 | 0
 | 2024-05-24 00:00:00 | ZIG | 0 |  | Cleaning | 2930 | P1 | Payment for general and administrative expenses | 0 | 0 | 2301 | Second Term |  | 126 | 0 | 0 | 0 | 126 | 0
 | 2024-05-24 00:00:00 | ZIG | 0 |  | Bank Charges | 3210 | P1 | Payment for general and administrative expenses | 0 | 0 | Mayb12 | Second Term |  | 2.52 | 0 | 0 | 0 | 2.52 | 0
 | 2024-05-24 00:00:00 | ZIG | 0 |  | Bank Charges | 3210 | P1 | Payment for general and administrative expenses | 0 | 0 | Mayb13 | Second Term |  | 2.4 | 0 | 0 | 0 | 2.4 | 0
 | 2024-05-28 00:00:00 | ZIG | 0 |  | Electricity | 2660 | P1 | Payment for general and administrative expenses | 0 | 0 | 2305 | Second Term |  | 260 | 0 | 0 | 0 | 260 | 0
 | 2024-05-28 00:00:00 | ZIG | 0 |  | Bank Charges | 3210 | P1 | Payment for general and administrative expenses | 0 | 0 | Mayb14 | Second Term |  | 5.2 | 0 | 0 | 0 | 5.2 | 0
 | 2024-05-28 00:00:00 | ZIG | 0 |  | Bank Charges | 3210 | P1 | Payment for general and administrative expenses | 0 | 0 | Mayb15 | Second Term |  | 2.6 | 0 | 0 | 0 | 2.6 | 0
 | 2024-05-30 00:00:00 | ZIG | 0 | ST 006 | PAYE | 2780 | P1 | Payment for general and administrative expenses | 0 | 0 | 2312B | Second Term | Sundry | 3000 | 0 | 0 | 0 | 3000 | 0
 | 2024-05-30 00:00:00 | ZIG | 0 |  | Bank Charges | 3210 | P1 | Payment for general and administrative expenses | 0 | 0 | Mayb16 | Second Term |  | 40 | 0 | 0 | 0 | 40 | 0
 | 2024-05-31 00:00:00 | ZIG | 0 |  | Bank Charges | 3210 | P1 | Payment for general and administrative expenses | 0 | 0 | Mayb17 | Second Term |  | 192 | 0 | 0 | 0 | 192 | 0
 | 2024-05-31 00:00:00 | ZIG | 0 |  | Bank Charges | 3210 | P1 | Payment for general and administrative expenses | 0 | 0 | Mayb18 | Second Term |  | 9.6 | 0 | 0 | 0 | 9.6 | 0