Which range includes a specific date

[NPuser]

I have a table of date ranges: school terms and holidays over three years.

How do I determine which range a specific date occurs within?