Reservation book template excel

It also mentions the title of contact, description of the event, target audience, facility requested, event timings as well as facility services, food services, tech services, etc. This facility reservation form presents event name, date and time of the event, a number of attendees, type of hall required for the event, hosting organization name, contact name, contact number, food service details as well as additional equipment details like a projector, television, etc.

This group reservation form presents trip date, arrival time, number of buses, group name, address including city, state, zip, contact name, phone number, email id, the number of adults and children, lunch time and additional options like pony rides, etc.

It provides zoo rules and regulations for visitors as well. This hotel reservation form presents the name, address, contact information, accommodation information, payment conditions, credit card information, bank account information and total amount payable. It also mentions booking information, payment conditions, as well as cancellation details like percentage of the amount, charges based on the timing of cancellation.

This library reservation form presents library name, membership details, contact name, address, city, state and zip, contact information, email id, the number of youth participants, the number of adults and hands-on program details including date and time. It requests the completed form to be emailed or faxed. This name reservation form presents the name of the entity to be reserved, type of the entity, name, address and contact information of the applicant as well as the client.

It also obtains the signature of the applicant. It provides detailed instructions about entity reservation including fee and payment details. This property reservation form presents details of property like property address, tenancy term, rent amount, conditions. Once that happens they essentially fill in the format with the dates and reservations as individuals call. The sheet does whatever remains of the work, ensuring that checking which rooms will be full should be possible at a solitary look.

There is a wide assortment of PC projects available that give inns an inn reservation format as a component of the product suite. You can find the template of your choice such as Hotel Reservation Template as it makes you relaxed and saves you from the hassle of customizing it each time.

The same is visible on the screenshot below. Against each room, under the dates, booked dates are highlighted in one color light orange and availability dates are highlighted in another color light blue. Why so? This is to avoid performance issues. You can select any start date by double-clicking the date picker in cell C1.

That means if you want you can see the past three months, current three months, future three months or any custom three months booking status on a calendar.

For example, if your start date is 01 Nov , you will get a booking calendar with booking status for the period 01 Nov to 31 Jan You can show the status of as many numbers of rooms as you wish. I have just included 10 rooms — Refer to the range Availability! There are three tabs sheets used in this reservation and booking calendar template in Google Sheets. They are;. In other words, these two columns are helper columns. There are of course formulas in this sheet that plays a vital role in the reservation and booking calendar template making in Google Sheets.

But those formulas are array formulas. So no need to copy-paste or make any manual adjustment. I have used this sheet as a helper sheet. In this sheet, there is one formula in cell D3, that requires your intervention in case of more than rows.

So that you can see the formulas in column D. In this section, I am going to share the formulas in use in all the tabs and their purposes. I hope, that will help you to modify the formulas, in case you want.

In Reservations! G3 I have the below array formula which populates the number of days booked from check-in and check-out dates of guests. So filtering the required data is important.

If the check-in date is less than the start date in cell Availability! C1 , the above formula will return the start date. Then if the check-in date is greater than the end date in cell Availability! G1 , the above formula will return blank, else it will return the check-in date as it is. If the check-out date is less than the start date in Availability! C1 , this formula will return blank, if check-out date is greater than the end date in Availability! G1 , then it will return the end date.

If not, I mean if both the above criteria do not meet, then the formula will return the check out date as it is. The following Query formula in cell Filtered! A2 filters the range Reservations! A2:J and returns the column A, I, and J. That means the room number column and the check-in and check out helper columns respectively. To expand check-in and check-out dates, I have entered the following Sequence formula in Filtered! D3 and copy-pasted to the rows down. Find those details below. We have reached the last part of how to make a reservation and booking staus calendar template in Google Sheets.

Right now we are in the Availability! You can see the below formula there which copied to the range C5:C There are three main functions in use in this formula — Filter , TextJoin , and Match.

The Filter formula filters the check-in and check-out expanded dates from Filtered! The criterion to filter is the room number. So the above filter formula output may contain multiple rows. The Texjoin combines multiple rows into one.

Read more. Was this helpful? Paula R. Reviewed by Paula R. Junior P. Reviewed by Junior P. Show more. Try the Free Trial Version This is a free limited version of the full product to help you try before you buy.