How to count the number of guests staying in a hotel every day in Excel?

You can use Excel’s pivot table function to make statistics on hotel occupancy. The specific steps are as follows:

Prepare data. Record the list of guests staying in the hotel every day in an Excel table, including check-in date, guest name and other information.

Insert a new row above the data table to label the column names.

In the new row, enter the column names such as "Date" and "Number of People".

Enter the check-in date in the "Date" column. You can use Excel's date format, such as "2022/3/23".

Enter "1" in the "Number of people" column, indicating that the number of guests is 1.

Select all cells in the data table, including column names and data.

Select the "Insert" tab in the Excel menu bar and click "Pivot Table".

In the "Pivot Table Creation Wizard", set the data table range to the selected cells, select the "New Worksheet" option, and click "Next".

Select "Date" in the "Row Area", select "Number of People" in the "Value Area", and set the statistical function to "Sum".

Click the "Finish" button, Excel will automatically generate a new worksheet, which contains the results of the daily occupancy statistics by date.

Using the pivot table function can easily classify, summarize and statistically analyze large amounts of data. It has the advantages of efficiency, flexibility, ease of use, etc., and is suitable for various data analysis scenarios.