Turning Check in and out dates into number of rooms per night for rooming lists

[kimkam212]

Hello! Hoping you can help me - I'm a meeting planner and have to send hotels rooming lists with the number of days stayed for each night. These lists can be hundreds of people long which can be a pain. I have names and check in and out dates and have to send the hotels that information, and then have to figure out the total number of rooms per night for all the people.

I've attached a simple spreadsheet here to show you what I'm talking about. Right now, I just go in and put "1" for each night, then add up the columns.
Do any of you sage folks have an easier way for me to do this? Believe it or not, I've been doing it this way for years and of course screw it up each time I have a lot of people staying at a hotel!

Thanks so much!
Kim

[AliGW]

How did you work out that you would have five people staying on 03 April?

[kimkam212]

Sorry, I uploaded the wrong sheet. I've just deleted the old one and uploaded the correct one. Thanks for looking AliGW!

[DBY]

Hello
In C20 across, try the following formula:

Please Login or Register  to view this content.

This didn't tally with your first sheet but seems consistent with your updated sheet.

DBY

[micope21]

Hi

There no easy wasy to put 1 in and looking at the sheet can lead to mistake!

Would you be happy to know how many days left for arrive and check out?

Worth to see it yourself? something a idea?

Cell G3

Please Login or Register  to view this content.

copy down. This for arrive

Cell H3

Please Login or Register  to view this content.

This for how many day left and check out

Just a idea whether this will help you or not?

[kimkam212]

This worked perfectly! Thank you - this is going to save me hours of my time!

[kimkam212]

I meant this for you of course - This worked perfectly! Thank you - this is going to save me hours of my time!