Spreadsheet: 90234d1289996606-conditional-formatting-calander-with-sumproduct-list-to-calander
Sheet: Sheet1

Name, Surname | Date in | Date out | rate p/night | etage | nbr jours loué 2em | CA brut 2em | nbr jours loué 4em | CA brut 4em | Observation(s) complementaire(s) |  |  | 2em etage |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4em etage
[NAME] | 2009-04-22 00:00:00 | 2009-04-26 00:00:00 |  | 2 |  |  |  |  |  |  | 2010 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
Elvis Prestly | 2009-05-24 00:00:00 | 2009-05-31 00:00:00 |  | 2 |  |  |  |  |  |  | 2010-01-12 00:00:00
[NAME] | 2009-06-08 00:00:00 | 2009-06-10 00:00:00 |  | 2 |  |  |  |  |  |  | 2010-02-12 00:00:00
Ming Foo | 2009-06-17 00:00:00 | 2009-06-24 00:00:00 |  | 2 |  |  |  |  |  |  | 2010-03-12 00:00:00
[NAME] | 2009-07-07 00:00:00 | 2009-07-23 00:00:00 |  | 2 |  |  |  |  |  |  | 2010-04-12 00:00:00
[NAME] | 2009-08-23 00:00:00 | 2009-09-18 00:00:00 |  | 2 |  |  |  |  |  |  | 2010-05-12 00:00:00
M. "Dude" Lebowski | 2009-09-11 00:00:00 | 2009-09-18 00:00:00 |  | 4 |  |  |  |  |  |  | 2010-06-12 00:00:00
[NAME] | 2009-10-01 00:00:00 | 2009-11-03 00:00:00 |  | 4 |  |  |  |  |  |  | 2010-07-12 00:00:00
Alotta Fagina | 2009-11-05 00:00:00 | 2009-11-08 00:00:00 |  | 4 |  |  |  |  |  |  | 2010-08-12 00:00:00
[NAME] | 2009-11-02 00:00:00 | 2009-11-10 00:00:00 |  | 2 |  |  |  |  |  |  | 2010-09-12 00:00:00
[NAME] | 2009-12-05 00:00:00 | 2009-12-18 00:00:00 |  | 2 |  |  |  |  |  |  | 2010-10-12 00:00:00
[NAME] | 2009-11-16 00:00:00 | 2009-12-19 00:00:00 |  | 4 |  |  |  |  |  |  | 2010-11-12 00:00:00
[NAME] | 2009-12-24 00:00:00 | 2010-01-01 00:00:00 |  | 2 |  |  |  |  |  |  | 2010-12-12 00:00:00
[NAME] | 2009-12-21 00:00:00 | 2010-01-04 00:00:00 |  | 4 |  |  |  |  |  |  | 2011 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
Loch Ness Monster | 2010-01-04 00:00:00 | 2010-01-10 00:00:00 |  | 4 |  |  |  |  |  |  | 2010-01-12 00:00:00
[NAME] | 2010-01-11 00:00:00 | 2010-01-20 00:00:00 |  | 4 |  |  |  |  |  |  | 2010-02-12 00:00:00
[NAME] | 2010-01-20 00:00:00 | 2010-01-24 00:00:00 |  | 2 |  |  |  |  |  |  | 2010-03-12 00:00:00
[NAME] | 2010-03-01 00:00:00 | 2010-03-19 00:00:00 |  | 4 |  |  |  |  |  |  | 2010-04-12 00:00:00
[NAME] | 2010-04-28 00:00:00 | 2010-05-01 00:00:00 |  | 4 |  |  |  |  |  |  | 2010-05-12 00:00:00
[NAME] | 2010-03-09 00:00:00 | 2010-05-04 00:00:00 |  | 2 |  |  |  |  |  |  | 2010-06-12 00:00:00
Dusty Roads | 2010-05-13 00:00:00 | 2010-05-16 00:00:00 |  | 4 |  |  |  |  |  |  | 2010-07-12 00:00:00
[NAME] | 2010-05-24 00:00:00 | 2010-05-31 00:00:00 |  | 4 |  |  |  |  |  |  | 2010-08-12 00:00:00
[NAME] | 2010-05-26 00:00:00 | 2010-06-05 00:00:00 |  | 2 |  |  |  |  |  |  | 2010-09-12 00:00:00
Norm Ality | 2010-06-02 00:00:00 | 2010-06-15 00:00:00 |  | 4 |  |  |  |  |  |  | 2010-10-12 00:00:00
[NAME] | 2010-06-12 00:00:00 | 2010-06-19 00:00:00 |  | 2 |  |  |  |  |  |  | 2010-11-12 00:00:00
Ella Mentary | 2010-06-11 00:00:00 | 2010-06-19 00:00:00 |  | 4 |  |  |  |  |  |  | 2010-12-12 00:00:00
Cliff [NAME] | 2010-06-26 00:00:00 | 2010-07-04 00:00:00 |  | 2 |  |  |  |  |  |  | 2012 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31 | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24 | 25 | 26 | 27 | 28 | 29 | 30 | 31
[NAME] | 2010-07-17 00:00:00 | 2010-07-21 00:00:00 |  | 4 |  |  |  |  |  |  | 2010-01-12 00:00:00
[NAME] | 2010-06-22 00:00:00 | 2010-07-22 00:00:00 |  | 4 |  |  |  |  |  |  | 2010-02-12 00:00:00
Ruby Lips | 2010-08-01 00:00:00 | 2010-09-18 00:00:00 |  | 4 |  |  |  |  |  |  | 2010-03-12 00:00:00
[NAME] | 2010-09-01 00:00:00 | 2010-09-20 00:00:00 |  | 2 |  |  |  |  |  |  | 2010-04-12 00:00:00
[NAME] | 2010-09-20 00:00:00 | 2010-09-30 00:00:00 |  | 4 |  |  |  |  |  |  | 2010-05-12 00:00:00
[NAME] | 2010-10-02 00:00:00 | 2010-10-09 00:00:00 |  | 4 |  |  |  |  |  |  | 2010-06-12 00:00:00
[NAME] | 2010-10-01 00:00:00 | 2010-10-10 00:00:00 |  | 2 |  |  |  |  |  |  | 2010-07-12 00:00:00
[NAME] | 2010-10-12 00:00:00 | 2010-10-19 00:00:00 |  | 4 |  |  |  |  |  |  | 2010-08-12 00:00:00
[NAME] | 2010-10-23 00:00:00 | 2010-10-30 00:00:00 |  | 4 |  |  |  |  |  |  | 2010-09-12 00:00:00
[NAME] | 2010-10-17 00:00:00 | 2010-11-28 00:00:00 |  | 2 |  |  |  |  |  |  | 2010-10-12 00:00:00
[NAME] | 2010-11-18 00:00:00 | 2010-12-02 00:00:00 |  | 4 |  |  |  |  |  |  | 2010-11-12 00:00:00
Des Picable | 2010-12-12 00:00:00 | 2010-12-30 00:00:00 |  | 2 |  |  |  |  |  |  | 2010-12-12 00:00:00
[NAME] | 2010-12-20 00:00:00 | 2010-12-29 00:00:00 |  | 4