Quote Originally Posted by MrShorty View Post
It seems like the simplest measure of "probability of occupancy" would be the fraction occupied in the current data set. Pseudocode =count(years occupied for a given date)/total number of years the data covers.
I may not been clear in my post. I need to determine occupancy per each day based on several years of data. It may take several steps to accomplish. I was thinking of doing this:
1. since I only have arrival and departure dates a macro will be needed to fill the rest of the dates in-between.
2. create a pivot table to display a number depending on occupancy. For example, I should see that a given day was occupied 3 times in 7 years. I can make a decision to adjust pricing based on that data.
3. Macro to loop to next row

Unless someone knows a simpler way, I could use help in creating that code.