This is a start...

This formula only relates to the # of days in the current month of the report.

I am looking to complete a report for the year, something like this:
I have 99 Rooms Available each day:
YTD NOV DEC JAN FEB MAR APR MAY
Rooms Sold 7700 800 2400 2000 2500
Rooms Avail 11800 2970 3069 3069 2772
# Days Avail 120 30 31 31 28
Occupancy % 65% 26% 78% 65% 90%

The formula provided will only provide the # days in the reported fiscal month. For past months, the # changes to the current month's number of days.

I could just drop the number of days on a line and show the occupancy each month but the YTD stats don't jive. Perhaps I just need the formula for the YTD column.