Spreadsheet: 95323d1294933484-excel-2007-adding-2-sets-of-data-to-a-single-calendar-calendar-test
Sheet: Calendar

 |  |  | Template & Install |  |  |  |  |  |  |  |  |  |  |  | Start Month: | 1
 |  |  | Calendar |  |  |  |  |  |  |  |  |  |  |  | Start Year: | 2011
 | 6
 | #N/A |  | 2011-01-01 00:00:00
 |  |  | Monday |  | Tuesday |  | Wednesday |  | Thursday |  | Friday |  | Saturday |  | Sunday
3 |  |  | 2010-12-27 00:00:00 | Unassigned | 2010-12-28 00:00:00 | Unassigned | 2010-12-29 00:00:00 | Unassigned | 2010-12-30 00:00:00 | Unassigned | 2010-12-31 00:00:00 | Unassigned | 2011-01-01 00:00:00 |  | 2011-01-02 00:00:00
4 |  |  | 40539 |  | 40540 |  | 40541 |  | 40542 |  | 40543 |  | 40544 |  | 40545
 |  |  |  | Template |  | Template |  | Template |  | Template |  | Template |  | Template
3 |  |  | 2011-01-03 00:00:00 |  | 2011-01-04 00:00:00 |  | 2011-01-05 00:00:00 |  | 2011-01-06 00:00:00 | KRAFT-HYATT RESTAURANT {Ramiro} 173.06 | 2011-01-07 00:00:00 | Stock-Classics Lot 18 {Ramiro} 130.25 | 2011-01-08 00:00:00 |  | 2011-01-09 00:00:00
 |  |  |  | Install |  | Install |  | Install |  | Install |  | Install |  | Install
4 |  |  | 40546 |  | 40547 |  | 40548 |  | 40549 |  | 40550 |  | 40551 |  | 40552
 |  |  |  | Template |  | Template |  | Template |  | Template |  | Template |  | Template | 2011-01-16 00:00:00
3 |  |  | 2011-01-10 00:00:00 |  | 2011-01-11 00:00:00 | Stock-Sarita 136 {Ramiro} 130.51 | 2011-01-12 00:00:00 |  | 2011-01-13 00:00:00 |  | 2011-01-14 00:00:00 |  | 2011-01-15 00:00:00 |  | 40559
 |  |  |  | Install |  | Install |  | Install |  | Install |  | Install |  | Install | 2011-01-23 00:00:00
4 |  |  | 40553 |  | 40554 |  | 40555 |  | 40556 |  | 40557 |  | 40558 |  | 40566
 |  |  |  | Template |  | Template |  | Template |  | Template |  | Template |  | Template | 2011-01-30 00:00:00 | 0
3 |  |  | 2011-01-17 00:00:00 |  | 2011-01-18 00:00:00 |  | 2011-01-19 00:00:00 | Stock-ALDEN WOODS 3-101 {Ramiro} 77.5  Stock-ALDEN WOODS 3-102 {Ramiro} 77.5  Stock-ALDEN WOODS 3-201 {Ramiro} 85.67  Stock-ALDEN WOODS 3-202 {Ramiro} 85.67 | 2011-01-20 00:00:00 |  | 2011-01-21 00:00:00 | Stock-CALDECOTT 13 {0} 105.15 | 2011-01-22 00:00:00 |  | 40573
4 |  |  | 40560 |  | 40561 |  | 40562 | #N/A | 40563 |  | 40564 |  | 40565 |  | 2011-02-06 00:00:00 | 0
 |  |  |  | Template |  | Template |  | Template |  | Template |  | Template |  | Template | 40580
3 |  |  | 2011-01-24 00:00:00 | Stock-MARTINIQUE 1 {0} 0 | 2011-01-25 00:00:00 |  | 2011-01-26 00:00:00 |  | 2011-01-27 00:00:00 |  | 2011-01-28 00:00:00 | 0 | 2011-01-29 00:00:00 | 0 | 2011-02-16 12:00:00 | 0
 |  |  |  | Install |  | Install |  | Install |  | Install |  | Install |  | Install | 40590.5
4 |  |  | 40567 |  | 40568 |  | 40569 |  | 40570 |  | 40571 |  | 40572
3 |  |  | 2011-02-03 12:00:00 | 0 | 2011-02-04 12:00:00 | 0 | 2011-02-05 12:00:00 | 0 | 2011-02-06 12:00:00 | 0 | 2011-02-07 12:00:00 | 0 | 2011-02-08 12:00:00 | 0
3 |  |  | 2011-01-31 00:00:00 | 0 | 2011-02-01 00:00:00 | 0 | 2011-02-02 00:00:00 | 0 | 2011-02-03 00:00:00 | 0 | 2011-02-04 00:00:00 | 0 | 2011-02-05 00:00:00 | 0
4 |  |  | 40574 |  | 40575 |  | 40576 |  | 40577 |  | 40578 |  | 40579
3 | #N/A |  | 2011-02-10 12:00:00 | 0 | 2011-02-11 12:00:00 | 0 | 2011-02-12 12:00:00 | 0 | 2011-02-13 12:00:00 | 0 | 2011-02-14 12:00:00 | 0 | 2011-02-15 12:00:00 | 0
4 | #N/A |  | 40584.5 |  | 40585.5 |  | 40586.5 |  | 40587.5 |  | 40588.5 |  | 40589.5