Lookup from a date to a date range

[jomili]

Some days I'm much stupider than others. This is one of those days.

In the attachment I have mileage expenses by the period in our fiscal year in which they were paid out (like "2024_01","2024_02").
I also have the "Service Date", the date they actually did the driving.

For each time period in which they drive (not when they get paid for it) they have a travel rate (cents per mile).

I need to convert these expenses to the miles they traveled (that info doesn't show in our expense files), which is the simple equation "Expense/Rate".
So, I need to do a lookup from the Service date to the corresponding date range to return the rate in place at the time.

That's where I'm drawing a blank, how do I lookup from a date to a date range?

If it helps to redo my little rate table that's not a problem, I haven't redone because I can't yet figure out how to approach this problem.

Any help would be appreciated.