MATCH values not in order

Hello, I'd like to know if there is any way I can use a MATCH formula - or something similar - to return a value when the lookup array isn't in ascending/descending order.

I have a grid of four rows, one row for each quarter and against three brands, and the values in the grid refer to the start dates of each quarter for each brand. In my line of work, quarter start dates don't adhere strictly to the calendar month. This is a rolling grid in that once I become aware of the next quarter start date, I overwrite last year's start date with this year's. In the below example, I know the Q1 2023 start date, but have not yet received the Q2 2023 start date, so the 2022 values are still in place.

;BRAND 1 ;BRAND 2 ;BRAND3
Q1;03/01/2023;05/01/2023;04/01/2023
Q2;01/04/2022;02/04/2022;01/04/2022
Q3;02/07/2022;02/07/2022;01/07/2022
Q4;04/10/2022;04/10/2022;05/10/2022

I also have a cell with =TODAY() in. I need to be able to identify the most recent quarter start date in a given column that is equal to or less than today's date, however, because the rolling grid will only ever be in ascending order for one quarter a year (Q4, once all dates for the year are known) the MATCH formula is unable to produce the result I need. Is there any solution to this?

Thanks,

Benedict