Screenshots for Google Spreadsheets

Writing a script for Google Spreadsheets. And that is:

Write the functional:
- Decorations of days of the week for each of the apartments that are vertically. Green color - the apartment, which, on the given date, free, red - occupied;
- Show the number of days to the next reservation, in case of no reservation for the given period - to the end of the period