Spreadsheet: 214571d1360969893-condtional-formatting-based-on-dates-ms
Sheet: Sheet1

 | DG1_PLN | DG1_ACT | M2_PLN | M2_ACT | M3_PLN | M3_ACT | M4_PLN | M4_ACT | DG2_PLN | DG2_ACT | M5_PLN | M5_ACT | M6_PLN | M6_ACT | M7_PLN | M7_ACT | M8_PLN | M8_ACT | DG3_PLN | DG3_ACT | M9_PLN | M9_ACT | [NAME] | DG4_ACT | M11_PLN | M11_ACT | TGT COMP | Milestone Phase
 | 2012-02-22 09:00:53 | 2012-02-22 09:00:53 | 2012-05-10 00:00:00 | 2012-05-10 00:00:00 | 2012-05-11 00:00:00 | 2012-05-11 00:00:00 | 2012-06-18 00:00:00 | 2012-06-18 00:00:00 | 2012-07-20 00:00:00 | 2012-07-10 00:00:00 | 2013-02-18 00:00:00 | 00:00:00 | 2013-09-26 00:00:00 | 00:00:00 | 2013-09-26 00:00:00 | 00:00:00 | 2013-09-26 00:00:00 | 00:00:00 | 2013-09-26 00:00:00 | 00:00:00 | 2013-09-30 00:00:00 | 00:00:00 | 2013-10-20 00:00:00 | 00:00:00 | 2013-10-30 00:00:00 | 00:00:00 | 2013-10-30 00:00:00 | Execution (Pre-Production) - Phase 3
 | 2011-10-07 16:30:50 | 2011-10-07 16:30:50 | 2012-01-13 00:00:00 | 2012-06-21 00:00:00 | 2012-02-03 00:00:00 | 2012-06-21 00:00:00 | 2012-04-06 00:00:00 | 2012-06-21 00:00:00 | 2012-05-25 00:00:00 | 2012-06-21 00:00:00 | 2012-05-25 00:00:00 | 2012-06-21 00:00:00 | 2012-07-31 00:00:00 | 2012-07-31 00:00:00 | 2012-09-28 00:00:00 | 2012-10-11 00:00:00 | 2012-11-19 00:00:00 | 2012-10-29 00:00:00 | 2012-11-30 00:00:00 | 2012-11-14 00:00:00 | 2013-01-09 00:00:00 | 2013-01-09 00:00:00 | 2013-01-09 00:00:00 | 00:00:00 | 2013-01-31 00:00:00 | 00:00:00 | 2013-01-31 00:00:00 | Execution (Post-Production) - Phase 4
 | 2012-10-24 10:00:47 | 2012-10-24 10:00:47 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2013-03-22 00:00:00 | Execution (Post-Production) - Phase 4
 | 2013-01-02 10:30:28 | 2013-01-02 10:30:28 | 00:00:00 | 00:00:00 | 2013-09-01 00:00:00 | 00:00:00 | 2013-10-01 00:00:00 | 00:00:00 | 2013-11-01 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2014-04-20 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2014-05-20 00:00:00 | Planning - Phase 2
 | 2012-02-17 15:31:13 | 2012-02-17 15:31:13 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2013-02-01 00:00:00 | Closure - Phase 5
 | 2012-08-30 15:31:04 | 2012-08-30 15:31:04 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2013-02-08 00:00:00 | Initiation - Phase 1
 | 2010-04-16 19:00:25 | 2010-04-16 19:00:25 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2013-07-22 00:00:00 | Execution (Post-Production) - Phase 4
 | 2012-03-21 12:02:08 | 2012-03-21 12:02:08 | 2012-08-21 00:00:00 | 2012-08-21 00:00:00 | 2012-09-24 00:00:00 | 2012-09-25 00:00:00 | 2013-01-04 00:00:00 | 2013-01-04 00:00:00 | 2013-02-13 00:00:00 | 00:00:00 | 2013-02-15 00:00:00 | 00:00:00 | 2013-02-21 00:00:00 | 00:00:00 | 2013-02-22 00:00:00 | 00:00:00 | 2013-02-25 00:00:00 | 00:00:00 | 2013-03-13 00:00:00 | 00:00:00 | 2013-03-17 00:00:00 | 00:00:00 | 2013-04-15 00:00:00 | 00:00:00 | 2013-04-17 00:00:00 | 00:00:00 | 2013-04-17 00:00:00 | Planning - Phase 2
 | 2012-04-17 11:31:16 | 2012-04-17 11:31:16 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2013-05-31 00:00:00 | Execution (Post-Production) - Phase 4
 | 2012-05-23 13:30:50 | 2012-05-23 13:30:50 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2013-03-08 00:00:00 | Closure - Phase 5
 | 2012-08-10 17:30:58 | 2012-08-10 17:30:58 | 2012-11-29 00:00:00 | 2012-11-29 00:00:00 | 2012-11-29 00:00:00 | 2012-11-29 00:00:00 | 2013-01-04 00:00:00 | 2013-01-04 00:00:00 | 2013-01-10 00:00:00 | 2013-01-10 00:00:00 | 2013-01-15 00:00:00 | 2013-01-15 00:00:00 | 2013-01-17 00:00:00 | 2013-01-17 00:00:00 | 2013-01-18 00:00:00 | 2013-01-18 00:00:00 | 2013-01-18 00:00:00 | 2013-01-18 00:00:00 | 2013-01-18 00:00:00 | 2013-01-18 00:00:00 | 2013-01-20 00:00:00 | 2013-01-20 00:00:00 | 2013-02-01 00:00:00 | 00:00:00 | 2013-02-17 00:00:00 | 00:00:00 | 2013-02-17 00:00:00 | Execution (Post-Production) - Phase 4
 | 2012-12-03 21:01:32 | 2012-12-03 21:01:32 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2013-04-15 00:00:00 | Planning - Phase 2
 | 2012-12-11 12:31:37 | 2012-12-11 12:31:37 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2013-08-18 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2013-10-31 00:00:00 | Planning - Phase 2
 | 2013-01-10 16:31:28 | 2013-01-10 16:31:28 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2013-10-21 00:00:00 | Execution (Post-Production) - Phase 4
 | 2012-08-02 16:01:47 | 2012-08-02 16:01:47 | 00:00:00 | 00:00:00 | 2013-04-01 00:00:00 | 00:00:00 | 2013-04-21 00:00:00 | 00:00:00 | 2013-05-28 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2013-06-01 00:00:00 | 00:00:00 | 2013-07-15 00:00:00 | 00:00:00 | 2013-08-31 00:00:00 | 00:00:00 | 2013-10-14 00:00:00 | 00:00:00 | 2014-07-20 00:00:00 | 00:00:00 | 2014-08-20 00:00:00 | 00:00:00 | 2014-08-20 00:00:00 | 00:00:00 | 2014-08-20 00:00:00 | Planning - Phase 2
 | 2012-08-02 16:01:37 | 2012-08-02 16:01:37 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2014-07-31 00:00:00 | Execution (Post-Production) - Phase 4
 | 2013-01-08 13:00:58 | 2013-01-08 13:00:58 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2013-07-31 00:00:00 | Planning - Phase 2
 | 2013-01-08 13:01:19 | 2013-01-08 13:01:19 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2013-07-31 00:00:00 | Planning - Phase 2
 | 2013-01-08 13:01:14 | 2013-01-08 13:01:14 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2013-07-31 00:00:00 | Planning - Phase 2
 | 2013-01-08 13:01:07 | 2013-01-08 13:01:07 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2013-07-31 00:00:00 | Planning - Phase 2
 | 2013-01-08 12:31:26 | 2013-01-08 12:31:26 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2013-07-31 00:00:00 | Planning - Phase 2
 | 2013-01-08 12:31:08 | 2013-01-08 12:31:08 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2013-07-31 00:00:00 | Planning - Phase 2
 | 2013-01-08 13:01:05 | 2013-01-08 13:01:05 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 00:00:00 | 2013-07-31 00:00:00 | Planning - Phase 2
 |  |  |  |  |  |  |  |  | This date expired and actual date has not been updated