Spreadsheet: 751714d1634275912-formula-to-group-dates-into-first-term-second-term-and-third-term-and-produce-debtors-lis-first-term
Sheet: Sheet1

Kindly asking for excel formula if the date is between January and April column K is First term, and if the date is between May and August, column K is Second term,
and if the date is between September and December, column K is Third term.  I'm also asking for Index match formula or any other formula to produce debtors analysis |  |  |  |  |  |  |  |  |  |  |  | Debtors Analysis
as shown in the desired solution |  |  |  |  |  |  |  |  |  |  |  | Desired solution
 |  | Transactions |  |  |  |  |  |  |  |  |  |  | drop down list
 | Code | Invoice | Payment Method | Date | Name | Receipt | Amount | Financial Category | Status | Term |  |  | [NAME]
1CT 003 | CT 003 | 2002 |  | 2021-01-01 00:00:00 | [NAME] |  | 700 | Opening Balance | Invoiced | First Term
1CT 004 | CT 004 | 2003 |  | 2021-01-01 00:00:00 | ANDILE B NCUBE |  | 1000 | Opening Balance | Invoiced | First Term |  | Term | Debit | Credit | Balance
1CT 005 | CT 005 | 2004 |  | 2021-01-01 00:00:00 | ANDREY NDAGURWA |  | 0 | Opening Balance | Invoiced | First Term |  | Opening Balance |  |  | 700
1CT 006 | CT 006 | 2005 |  | 2021-01-01 00:00:00 | ANGELLA CHANGE |  | 26607 | Opening Balance | Invoiced | First Term |  | First Term | 23375
1CT 007 | CT 007 | 2006 |  | 2021-01-01 00:00:00 | [NAME] |  | 0 | Opening Balance | Invoiced | First Term |  | First Term
1CT 008 | CT 008 | 2007 |  | 2021-01-01 00:00:00 | ASHER TAMIREPI |  | -4000 | Opening Balance | Invoiced | First Term |  | Second Term | 24500
 |  |  |  |  |  |  |  |  |  |  |  | Second Term |  | 27500
2CT 003 | CT 003 | 2010 |  | 2021-01-22 00:00:00 | [NAME] |  | 23375 | Sales | Invoiced | First Term |  | [NAME] | 25100
2CT 004 | CT 004 | 2011 |  | 2021-01-22 00:00:00 | ANDILE B NCUBE |  | 23375 | Sales | Invoiced | First Term |  | [NAME] |  | 14875
2CT 005 | CT 005 | 2012 |  | 2021-01-22 00:00:00 | ANDREY NDAGURWA |  | 23375 | Sales | Invoiced | First Term
2CT 006 | CT 006 | 2013 |  | 2021-01-22 00:00:00 | ANGELLA CHANGE |  | 23375 | Sales | Invoiced | First Term
2CT 007 | CT 007 | 2014 |  | 2021-01-22 00:00:00 | [NAME] |  | 23375 | Sales | Invoiced | First Term
2CT 008 | CT 008 | 2015 |  | 2021-01-22 00:00:00 | ASHER TAMIREPI |  | 23375 | Sales | Invoiced | First Term
 |  |  |  |  |  |  |  |  |  | First Term
3CT 003 | CT 003 | 2 | Bank | 2021-01-22 00:00:00 | [NAME] | 25 | 11500 | Fees | Received | First Term
3CT 004 | CT 004 | 3 | Bank | 2021-02-01 00:00:00 | ANDILE B NCUBE | 26 | 20000 | Fees | Received | First Term
3CT 005 | CT 005 | 4 | Cash | 2021-03-22 00:00:00 | ANDREY NDAGURWA | 27 | 2572 | Fees | Received | First Term
3CT 006 | CT 006 | 5 | Cash | 2021-03-30 00:00:00 | ANGELLA CHANGE | 28 | 22572.9 | Fees | Received | First Term
3CT 007 | CT 007 | 6 | Bank | 2021-04-10 00:00:00 | [NAME] | 29 | 5180 | Fees | Received | First Term
3CT 008 | CT 008 | 7 | Bank | 2021-04-12 00:00:00 | ASHER TAMIREPI | 30 | 6567.7 | Fees | Received | First Term
4CT 003 | CT 003 | 2 | Bank | 2021-01-22 00:00:00 | [NAME] | 31 | 11500 | Fees | Received | First Term
5CT 003 | CT 003 | 2016 |  | 2021-05-22 00:00:00 | [NAME] |  | 24500 | Sales | Invoiced | Second Term
4CT 004 | CT 004 | 2017 |  | 2021-05-22 00:00:00 | ANDILE B NCUBE |  | 24500 | Sales | Invoiced | Second Term
4CT 005 | CT 005 | 2018 |  | 2021-05-22 00:00:00 | ANDREY NDAGURWA |  | 24500 | Sales | Invoiced | Second Term
4CT 006 | CT 006 | 2019 |  | 2021-05-22 00:00:00 | ANGELLA CHANGE |  | 24500 | Sales | Invoiced | Second Term
4CT 007 | CT 007 | 2020 |  | 2021-05-22 00:00:00 | [NAME] |  | 24500 | Sales | Invoiced | Second Term
4CT 008 | CT 008 | 2021 |  | 2021-05-22 00:00:00 | ASHER TAMIREPI |  | 24500 | Sales | Invoiced | Second Term
 |  |  |  |  |  |  |  |  |  | Second Term
6CT 003 | CT 003 |  | Bank | 2021-05-22 00:00:00 | [NAME] | 32 | 27500 | Fees | Received | Second Term
5CT 004 | CT 004 |  | Bank | 2021-05-30 00:00:00 | ANDILE B NCUBE | 33 | 27500 | Fees | Received | Second Term
5CT 005 | CT 005 |  | Cash | 2021-06-22 00:00:00 | ANDREY NDAGURWA | 34 | 7500 | Fees | Received | Second Term
5CT 006 | CT 006 |  | Cash | 2021-08-10 00:00:00 | ANGELLA CHANGE | 35 | 12000 | Fees | Received | Second Term
5CT 007 | CT 007 |  | Bank | 2021-08-22 00:00:00 | [NAME] | 36 | 20000 | Fees | Received | Second Term
5CT 008 | CT 008 |  | Bank | 2021-08-22 00:00:00 | ASHER TAMIREPI | 37 | 13375 | Fees | Received | Second Term
6CT 006 | CT 006 |  | Bank | 2021-08-30 00:00:00 | ANGELLA CHANGE | 38 | 12000 | Fees | Received | Second Term
7CT 003 | CT 003 | 2022 |  | 2021-05-22 00:00:00 | [NAME] |  | 25100 | Sales | Invoiced | [NAME]
6CT 004 | CT 004 | 2023 |  | 2021-05-30 00:00:00 | ANDILE B NCUBE |  | 25100 | Sales | Invoiced | [NAME]
6CT 005 | CT 005 | 2024 |  | 2021-06-22 00:00:00 | ANDREY NDAGURWA |  | 25100 | Sales | Invoiced | [NAME]
7CT 006 | CT 006 | 2025 |  | 2021-08-10 00:00:00 | ANGELLA CHANGE |  | 25100 | Sales | Invoiced | [NAME]
6CT 007 | CT 007 | 2026 |  | 2021-08-22 00:00:00 | [NAME] |  | 25100 | Sales | Invoiced | [NAME]
6CT 008 | CT 008 | 2027 |  | 2021-08-22 00:00:00 | ASHER TAMIREPI |  | 25100 | Sales | Invoiced | [NAME]
 |  |  |  |  |  |  |  |  |  | [NAME]
8CT 003 | CT 003 |  | Bank | 2021-05-22 00:00:00 | [NAME] | 39 | 14875 | Fees | Received | [NAME]
7CT 004 | CT 004 |  | Bank | 2021-05-30 00:00:00 | ANDILE B NCUBE | 40 | 18700 | Fees | Received | [NAME]
7CT 005 | CT 005 |  | Cash | 2021-06-22 00:00:00 | ANDREY NDAGURWA | 41 | 8500 | Fees | Received | [NAME]
8CT 006 | CT 006 |  | Cash | 2021-08-10 00:00:00 | ANGELLA CHANGE | 42 | 17850 | Fees | Received | [NAME]
7CT 007 | CT 007 |  | Bank | 2021-08-22 00:00:00 | [NAME] | 43 | 17850 | Fees | Received | [NAME]
7CT 008 | CT 008 |  | Bank | 2021-08-22 00:00:00 | ASHER TAMIREPI | 44 | 10000 | Fees | Received | [NAME]