Quick and easy. Solution attached.
Used filter to exclude cancellations and no-shows. Formula to concatenate check-in date. Two date time tools to convert check-in and check-out from string to dates. Formula for DateTimeDiff function to get length of stay. Another filter to exclude 0s. A third Date Time to extract Month name from date. Summary to aggregate it all.