How to test if a date is part of certain periods (each defined by a start date and end date)

Hello everyone,
here my very first post on this community :slight_smile:
I am working on a use case to learn how to use make.
My idea was to create a simple booking system for a room (like airbnb for example).
The back end will be done qith airtbale (so that I can learn how to use another new tool :))
For the pricing, I have increase the difficulty by adding some high seasons (defined by an start date, and end date).

But unfortunately, I got lost in the repeater, array, and map(), get() function.
I would highly appreciate your help to debug my scenario.

I will attached my scenario:
back-end booking system.json (155.0 KB)

and also here some screenshots: