Hello,

As an assignment I need to be able to calculate the price of a hotel room according to what season it's in (high, mid, low) but the seasons differ by date.
For example: A room booked from the 10th of April to the 17th of April costs 100 euros a day for high season and 75 euros a day for mid season. The days from the 10th of April to the 13th of April are high season (100 euros) and the days from the 14th to the 17th are mid season (75 euros).

I don't know how to do this as the days that are high, mid or low season change day by day (18th of April to 20th is low season, 21st to 22nd mid, 23rd to 27th low again). Is there any way to do this efficiently or a way to do this at all?

This is an image showing the high, mid and low seasons. High is orange, mid is gray, low is white. (http://i.imgur.com/Wq3MrFx.jpg)

Thank you in advance,

Shadir