Calculate rental spanning different seasonal rental rates

Thanks etaf

The cels are commented with what I am trying to achieve.

Really not good at working with dates so just need to know how to look up the rate table for the appropriate number of days.