I'm a newbie for excel. I'm working on one spreadsheet. I want to find out total nights(month wise) from check-in and check out date, Vacancy % (month wise), and Avg Night rate (month wise).
I've created rough format in google spreadsheet. Please check this https://docs.google.com/spreadsheets...0zw/edit#gid=0
Please make a copy of this file and then add your formulas and share a new link here.
Thank you in advance. Looking forward to get a quick reply because it's bit urgent for me. This is just request.
Let me know if you have any questions.