Check date falls between period

[neodjandre]

I have a table as follows

Row 1 03-Mar-20... 03-Mar-21... 03-Mar-22... 03-Mar-23... 03-Mar-24...
Row 2 02-Mar-21... 02-Mar-22... 02-Mar-23... 02-Mar-24... 02-Mar-25...
Row 3 T1... T2... T3... T4... T5... .. up to T10

I am looking for an Index/Match type of formula, so if I give a specific date for example 05-Jun-23, it would return "T4".

The period dates are always sequential and do not overlap.

Any help is much appreciated.

 

[Special-K99]

Why would 05-Jun-23 return T4?

T4 is the fourth column according to row 3

Row 2 and Row 1 data for fourth column is 02-Mar-24 and 03-Mar-23.
That date range is outside of 05-Jun-23
So why should T4 be returned?