Please advise the formula to report the # days past within the selected periods.

My objective is to provide occupancy percentages for each month and YTD as well. Ideally, only days past would be included in the statistics.

eg. 100 Rooms available each day in January equals 3100 rooms available to sell. Sold rooms of 2100 would equate to 67% occupancy.