Spreadsheet: 146755d1332342362-how-to-create-a-rule-depending-on-date-periods-vlookup-true-rental-guest-stay-calculation-table
Sheet: Room only

 | Хармони Хилс Резиденс – 2012 (Тип на настаняване – “ROOM ONLY”) -Booking.com
 | Studio | 2 pax | 22/04-30/04 |  |  |  | 01/05-19/06 |  |  |  | 20/06-10/07 |  |  |  | 11/07-20/08 |  |  |  | 21/08-05/09 |  |  |  | 06/09-15/09 |  |  |  | 16/09-30/09 |  |  |  | 01/10-22/12 |  |  |  | 23/12-02/01
 |  |  | 28 |  |  |  | 31 |  |  |  | 37 |  |  |  | 45 |  |  |  | 37 |  |  |  | 31 |  |  |  | 29 |  |  |  | 25 |  |  |  | 30
 | 1-Bedroom Apartment | 2 pax | 22/04-30/04 |  |  |  | 01/05-19/06 |  |  |  | 20/06-10/07 |  |  |  | 11/07-20/08 |  |  |  | 21/08-05/09 |  |  |  | 06/09-15/09 |  |  |  | 16/09-30/09 |  |  |  | 01/10-22/12 |  |  |  | 23/12-02/01
 |  |  | 36 |  |  |  | 39 |  |  |  | 46 |  |  |  | 56 |  |  |  | 46 |  |  |  | 39 |  |  |  | 37 |  |  |  | 35 |  |  |  | 38
 | 2-Bedroom Apartment | 4 pax | 22/04-30/04 |  |  |  | 01/05-19/06 |  |  |  | 20/06-10/07 |  |  |  | 11/07-20/08 |  |  |  | 21/08-05/09 |  |  |  | 06/09-15/09 |  |  |  | 16/09-30/09 |  |  |  | 01/10-22/12 |  |  |  | 23/12-02/01
 |  |  | 44 |  |  |  | 47 |  |  |  | 56 |  |  |  | 68 |  |  |  | 56 |  |  |  | 47 |  |  |  | 45 |  |  |  | 43 |  |  |  | 50
 | 2-Bedroom Villa | 4 pax | 22/04-30/04 |  |  |  | 01/05-19/06 |  |  |  | 20/06-10/07 |  |  |  | 11/07-20/08 |  |  |  | 21/08-05/09 |  |  |  | 06/09-15/09 |  |  |  | 16/09-30/09 |  |  |  | 01/10-22/12 |  |  |  | 23/12-02/01
 |  |  | 48 |  |  |  | 51 |  |  |  | 61 |  |  |  | 79 |  |  |  | 61 |  |  |  | 51 |  |  |  | 59 |  |  |  | 47 |  |  |  | 54
 | 3-Bedroom Villa | 6 pax | 22/04-30/04 |  |  |  | 01/05-19/06 |  |  |  | 20/06-10/07 |  |  |  | 11/07-20/08 |  |  |  | 21/08-05/09 |  |  |  | 06/09-15/09 |  |  |  | 16/09-30/09 |  |  |  | 01/10-22/12 |  |  |  | 23/12-02/01
 |  |  | 54 |  |  |  | 59 |  |  |  | 67 |  |  |  | 88 |  |  |  | 67 |  |  |  | 59 |  |  |  | 57 |  |  |  | 50 |  |  |  | 60
 | Date | Studio | 1Bed | 2Bed | 2Villa | 3Villa |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Price |  |  |  |  |  |  | [NAME] | Price
 | 2012-01-01 00:00:00 | 28 | 36 | 44 | 48 | 54 | <<Build a Table like this. |  |  |  |  |  |  |  |  |  |  |  | 2012-02-27 00:00:00 |  |  |  | << 3 = 1 Bed |  |  |  | 2012-06-15 00:00:00 |  |  |  | <<<Look at this formula
 | 2012-04-30 00:00:00 | 31 | 39 | 47 | 51 | 59 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-02-28 00:00:00 |  |  |  |  |  |  |  | 2012-06-16 00:00:00 |  |  |  | << The 5 is for a 2 Villa
 | 2012-06-19 00:00:00 | 37 | 46 | 56 | 61 | 67 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-02-29 00:00:00 |  |  |  |  |  |  |  | 2012-06-17 00:00:00
 | 2012-07-10 00:00:00 | 45 | 56 | 68 | 79 | 88 |  |  |  |  |  |  |  |  |  |  |  |  | 2012-03-01 00:00:00 |  |  |  |  |  |  |  | 2012-06-18 00:00:00
 | 2012-08-20 00:00:00 | 37 | 46 | 56 | 61 | 67 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-06-19 00:00:00
 | 2012-09-05 00:00:00 | 31 | 39 | 47 | 51 | 59 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-06-20 00:00:00
 | 2012-09-15 00:00:00 | 29 | 37 | 45 | 59 | 57 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-06-21 00:00:00
 | 2012-09-30 00:00:00 | 25 | 35 | 43 | 47 | 50 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-06-22 00:00:00
 | 2012-12-22 00:00:00 | 30 | 38 | 50 | 54 | 60 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-06-23 00:00:00
 | 2013-01-02 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-06-24 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-06-25 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-06-26 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-06-27 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-06-28 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-06-29 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-06-30 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-07-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-07-02 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-07-03 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-07-04 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-07-05 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-07-06 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-07-07 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-07-08 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-07-09 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-07-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-07-11 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-07-12 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-07-13 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-07-14 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-07-15 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-07-16 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-07-17 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-07-18 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-07-19 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-07-20 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-07-21 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-07-22 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-07-23 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-07-24 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-07-25 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-07-26 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-07-27 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-07-28 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-07-29 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2012-07-30 00:00:00