Actually i found a better solution its to use a drop down menu with the data validation tool, i can now manage the booking codes and remove them if needed to prevent overbooking a specific date by removing the date from the drop down menu. Voila