Spreadsheet: 121567d1316162678-populate-dates-with-number-of-days-test-didb
Sheet: Sheet3

 | Day |  | Monday |  | Num | Venue | Company Name | Description | Days | Status | Contact Name | Contact Number | Notes |  |  |  | E-Mail | Rate | Basic Rate | [NAME] | Extra | Bar | Total
 | Date |  | 2011-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | should be |  | formula
 | Conference 1 |  |  |  | 1 | Conference 1 | Clearmark | Conf (Gov) FD | 5 | Preferred | Henk | [PHONE] |  |  |  |  | [EMAIL] | 375 |  | 5000 | 10000 | 15000 |  |  |  | 2011-01-02 00:00:00
 | Pax |  |  |  | 2 | Conference 2 | Bulls | Conf (Corp) FD | 2 | Preferred | Nadia | 0123456 |  |  |  |  | [EMAIL] | 200 |  | 2000 | 5000 | 15000 |  |  |  | 2011-01-03 00:00:00
 | Rate |  |  |  | 3 | Conference 3 | DIDB | Conf (Gov) HD | 1 | Quotation | [NAME] | [PHONE] |  |  |  |  | [EMAIL] | 375 |  | 6000 | 6000 | 15000 |  |  |  | 2011-01-04 00:00:00
 | Contact Name |  |  |  | 4 | Conference 4 | [NAME] | Conf (Corp) HD | 3 | Confirmed | Christie | [PHONE] |  |  |  |  | [EMAIL] | 450 |  | 2000 | 5000 | 15000 |  |  |  | 2011-01-05 00:00:00
 | Contact Number |  |  |  | 5 | Banquet 1 | Nokia | Wedding | 2 | Provisional | [NAME] | [PHONE] |  |  |  |  | [EMAIL] | 450 |  | 5000 | 3500 | 15000
 | Description |  |  |  | 6 | Banquet 2 | DTI | Wedding | 1 | Completed | [NAME] | [PHONE] |  |  |  |  | [EMAIL] | 275 |  | 1200 | 2500 | 15000
 | Conference 2 |  |  |  | 7 | Chapel | LG | Function | 5 | Provisional | [NAME] | [PHONE] |  |  |  |  | [EMAIL] | 375 |  | 1500 | 4500 | 15000
 | Pax |  |  |  | 8 |  |  |  |  |  |  |  |  |  |  |  | mailto:[EMAIL]
 | Rate |  |  |  | 9 |  |  |  |  |  |  |  |  |  |  |  | mailto:[EMAIL]
 | Contact Name |  |  |  | 10 |  |  |  |  |  |  |  |  |  |  |  | mailto:[EMAIL]
 | Contact Number |  |  |  | 11 |  |  |  |  |  |  |  |  |  |  |  | mailto:[EMAIL]
 | Description |  |  |  | 12 |  |  |  |  |  |  |  |  |  |  |  | mailto:[EMAIL]
 | Conference 3 |  |  |  | 13 |  |  |  |  |  |  |  |  |  |  |  | mailto:[EMAIL]
 | Pax |  |  |  | 14 |  |  |  |  |  |  |  |  |  |  |  | mailto:[EMAIL]
 | Rate |  |  |  | 15 |  |  |  |  |  |  |  |  |  |  |  | mailto:[EMAIL]
 | Contact Name |  |  |  | 16
 | Contact Number |  |  |  | 17
 | Description |  |  |  | 18
 | Conference 4 |  |  |  | 19
 | Pax |  |  |  | 20
 | Rate |  |  |  | 21
 | Contact Name |  |  |  | 22
 | Contact Number |  |  |  | 23
 | Description |  |  |  | 24
 | Banquet 1 |  |  |  | 25
 | Pax
 | Rate |  |  |  |  | Status | Daily Totals |  |  |  |  |  |  |  |  |  | Totals
 | Contact Name |  |  |  |  | Quotation
 | Contact Number |  |  |  |  | Preferred
 | Description |  |  |  |  | Provisional
 | Banquet 2 |  |  |  |  | Confirmed
 | Pax |  |  |  |  | Completed
 | Rate
 | Contact Name |  |  |  |  | Total
 | Contact Number
 | Description
 | Chapel
 | Pax
 | Rate
 | Contact Name
 | Contact Number
 | Description
 | Chapel (15h00)
 | Pax
 | Rate
 | Contact Name
 | Contact Number
 | Description
 | Chapel (17h00)
 | Pax
 | Rate
 | Contact Name
 | Contact Number
 | Description
 | Board Room
 | Pax
 | Rate
 | Contact Name
 | Contact Number
 | Description
 | Gazebo
 | Pax
 | Rate
 | Contact Name
 | Contact Number
 | Description
 | Transport
 | Pax
 | Rate
 | Contact Name
 | Contact Number
 | Description