#1
|
|||
|
|||
accommodation booking spreadsheet
A1 is the commencement date
B1 is the end of stay date C1 is titled Rooms C2 to C100 are room numbers From D1 the next 365 cells are the days of the year My question to the group is does anyone know of a formula that if A1 and B1 are entered with dates, the formula searched all cells in rooms and dates and shades them accordingly? Equally if anyone has previously made a accommodation spreadsheet can you please advise? Thanks M |
#2
|
|||
|
|||
Hi,
you might like to look at this link. http://www.onlinepclearning.com/exce...ooking-system/ Maybe this will help you getting started with it! HTH SW |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
creating a booking form | dougers1 | Word | 1 | 08-12-2016 08:22 PM |
Booking meetings spanning several days | John_G | Outlook | 0 | 03-30-2015 08:53 AM |
calendar booking | vicissitude24 | Outlook | 0 | 03-04-2015 02:20 AM |
Using Calendar for booking in laptops | workingitout33 | Outlook | 0 | 02-16-2015 01:19 PM |
Booking A Conference Room | tsingerjr | Outlook | 0 | 02-17-2009 11:43 AM |