I have a sheet with arrival and departure date and time.
I would like to calculate the following at 18:00 on each day:
- Occupancy (This has been resolved)
- Average length of stay of those currently staying
- Number of guests staying 7 days or more
The attached file explains my request more clearly.
Thanks in advance.
DVS
Bookmarks