Hi all,
I'm not sure if this is something that Excel will be able to help me with, but thought I would post and ask if anyone has any ideas.
I work for an organisation where we rent out rooms for people to stay in. There are different charges depending on the day of the week (weekday, Saturday, Sunday, Public Holiday) and people set up a certain number of these types of night to begin with for, say, 12 months. We need to know when taking a booking how many of each night type they have left.
What I want is to integrate a counting mechanism with our booking system, which looks something like this:
25/06/2018 26/06/2018 27/06/2018 28/06/2018 29/06/2018 30/06/2018 1/07/2018
Monday Tuesday Wednesday Thursday Friday Saturday Sunday
Bedroom 1 Jane Jane Jane Jane Jane Jane Jane
Bedroom 2 Tom Tom Tom Bob Bob Bob Bob
Bedroom 3 Alice Alice Alice Alice
And I want Excel to count and collate the various day types for each person.
Total Weekdays Weekdays Used Total Saturdays Saturdays Used Total Sundays Sundays Used Total Public Holidays Public Holidays Used
Jane 20 5 10 1 10 1 2 0
Tom 10 3 10 0 10 0 5 0
Bob 35 2 5 1 5 1 1 0
Alice 20 2 2 1 2 1 1 0
I am happy to have multiple sheets (eg. if I need a list of Public Holiday dates), but it probably wouldn't be viable to have a sheet per user as it we have 100+ clients and always having more.
Any assistance would be much appreciated!
Thanks,
Erin
Bookmarks