Forum

Notifications
Clear all

Retrieving data by day

6 Posts
3 Users
0 Reactions
142 Views
(@usb)
Posts: 244
Honorable Member
Topic starter
 

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

 
Posted : 01/05/2018 8:23 am
(@sunnykow)
Posts: 1417
Noble Member
 

Hi lea

See if this helps.

Sunny

 
Posted : 01/05/2018 11:17 am
(@usb)
Posts: 244
Honorable Member
Topic starter
 

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!!!

 
Posted : 02/05/2018 8:13 am
Anders Sehlstedt
(@sehlsan)
Posts: 977
Prominent Member
 

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

 
Posted : 02/05/2018 2:55 pm
(@usb)
Posts: 244
Honorable Member
Topic starter
 

Excellent answer !!
Thank you very much !!

 
Posted : 02/05/2018 3:11 pm
Anders Sehlstedt
(@sehlsan)
Posts: 977
Prominent Member
 

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

 
Posted : 02/05/2018 3:28 pm
Share: