In the attached file I have a hotel registration
And write a range of dates of the client and which room he took and the number of participants
And I need to know what every day was -
Some adults, some children and some rooms of every kind were booked at the hotel.
I made a table on the left
I would like to help how can you know what happened every day?
Thank you
Hi lea
See if this helps.
Sunny
I know the function you put in the file
And I want to sharpen my question more -
Column A reads the hotel's entry date
Column B provides a date of departure from the hotel
And focus on the 5th of the month -
There are customers who entered then so the function counted them
But there are customers who came in on the 3rd of the month and stayed at the hotel on the 5th of the month
And the function did not count them.
How can you count by the days the customer was at the hotel?
If Excel says only its date of entry and exit?
Thank you!!!
Hello Lea,
You need to use array formulas to sum / count the number of guests and rooms.
See attached file for reference.
To be able to use same array formula to also count the room types I had to do some re-arrangements of your data structure.
Br,
Anders
Excellent answer !!
Thank you very much !!
Hi Lea,
As you probably noticed, I was not sure how you wanted to count based on CheckOut date, so I gave two different options.
Just glad I could help.
Have a nice day!
Br,
Anders
