Need Some Help With a Dynamic Model

Hey, this is my first post so I'll try to be as detailed and succinct as possible. I have an excel worksheet with around 2450 entries. Each entry (row) has information about a specific hotel booking at the same hotel. The hotel in question has 7 rooms. The columns of the worksheet have the date the reservation was made, the arrival date, the checkout date, the number of nights stayed, and the number of rooms reserved. What I need is to create another column which tells me how many rooms were available at the time that the booking was made.

Any thoughts?
Thanks so much for your help.

Thank you, Here's the workbook I'm working with. I tried setting up a matrix where days from beginning to end would be in columns and each entry would basically "ping" on the dates that the guest arrives. Unfortunately, the matrix was massive (2500x2000 ish) and crashed my comp.

Any ideas? I'm totally at a loss on how to do this apart from manually entering it

Thats actually close to what I need, thanks so much for working on it. What I need is to know how many rooms were available at the time of the booking. So at the date in the "status date" column, how many rooms were remaining on the arrive date? (if entries were booked at the same time, it's no big deal which is included first)

It'd be even better if there was some sort of way to split the rows that have more than one under the "nights" column into a separate entry for each night they stayed. (ie price/room type/everything else is the same but now there is a new row inserted under the old row that says 1 night, and the new check-in/checkout date.

Thanks so much for your help so far!

Thanks so much, that looks great. I may be mistaken, but wouldn't this be problematic when the "nights" column when someone stays more than one night? So if they are staying for a week, their reservation for the first night would look like they booked 7 rooms. So when the previous entry booked 10 nights,it looks like there are -3 rooms available at the time of the next booking. Is there a way to automatically split the rows so that each night's booking is an individual row?

Is there a way to set up a macro that would split the rows up so that each row is a single day entry?

Anyone? Still struggling here haha