Hi,

I am working on a summary sheet for my seasonal property rental business, and am trying to summarise 10 years worth of data from the previous owners to help me with my own projections.

I have a vast list of previous contracts with Start Dates, and End Dates for each, as well as a large list of rentals during that time.

I need to know during each contract period (for example 1-Jan-2003 => 31-Mar-2011), how many of these days were high season, low season & holiday season. (for example holiday season : 22-Dec => 5-Jan).
If all it took was to calculate how many years, and how many days in a high-season, this would be easy, but using the numbers included above, only 5 days out of the 14 day high season range actually fall into the managed period.

I have been working on so many other summaries, that I have been able to figure out, that this one is starting to give me brain-cramps.

Thanks in advance for any help.