Hi,
I currently have a formula in excel which fills in a calendar from a booking list. However, I need to slightly develop the formula so that the calendar is filled automatically across several dates, rather than just one date, from an additional entry.
The formula currently in each cell within the calendar is:
=IF(SUMPRODUCT((INDIRECT("$B$14:$B$5000")=$A4)*(INDIRECT("$F$14:$F$5000")=SUBSTITUTE(B$3,"Room","")+0)),"X","")
It basically puts an "X" in the cell within the calendar in the right date and place if it matches the date and room number in the booking list. However, I would also like it to fill in across dates for the amount of nights entered separately in the booking list.
Please could someone first tell me if the formula I used is the most effective and also how this can be done.
I have attached the example excel file. It should work, but if not it is also shown below.
Kind regards,
Daniel
Bookmarks