Formula for finding within range of dates

[sharky123]

Hello
I have a sheet with alot of information regarding guest hotel.
The important for me now is :
Column A is checking day
Column B is the checkout day
And column c ....all the guest information.


Thers is some guests that stay 2 nights and there is another guests that stay 40 nights.

I want to put on a specific cell range of dates for example 01/09 and 05/09 .
And the return answer will be all the lines with the information of all the guest that stay at the hotel within these days.
All the lines that within the checkin date and checkout day.
All the guest that stay in the hotel at the 01/09, 02,09, 03/09, 04/09 and 05/09.

Any suggestions?

Thanks
Shark Man

[sharky123]

Hello Experts

I want to be more clear.
I want that the return information will be guest that stay in the hotel withing one of the day range
for example if the input date is 01/09 till 05/09 :
Guest that stay from 03/09 till 03/10 will be there
Guest that stay from 01/08 till 01/09 will be there
Guest that stay from 06/08 till 06/10 will be there
Guest that stay from 30/08 till 31/08 will not be there

Thanks, i hope it's clear

Shark man

[sharky123]

Experts

Please help, the guest will run away from the hotel

[JeteMc]

Without seeing the way your spreadsheet is laid out it is pretty hard to come up with a solution. This solution will work for the layout attached. The array entered formula* that finds guests that stayed at the hotel during the dates indicated is:

Please Login or Register  to view this content.

To upload a sample spreadsheet with your layout click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.
Let me know if you have any questions

[sharky123]

Hello to you

Thank you very much its awesome.

Please find attached example of my excel sheet

Obviously i have a lot of information in the table relating to the guest or group of guests

Is it possible to create something like pivot table or automatically new sheet table with the relevant information according the
range date category ?

Thanks a lot

Shark Man

[JeteMc]

Here is an example of how a table could be set up on a separate sheet using a variation of the array entered formula in post #4.
Let me know if you have any questions.