Spreadsheet: 146661d1332288750-formula-to-show-percentage-on-and-off-data
Sheet: Sheet1

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Green
 |  |  |  |  |  |  | Green | 9 |  |  |  |  |  |  |  |  |  | Red
 |  |  |  |  |  |  | Red | 6 |  |  |  |  |  |  |  |  |  | Blue
 |  | Left Course 10 Wks |  | 3 |  |  | Blue | 5 |  |  |  |  |  |  |  |  |  | Monday
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tuesday
 |  | Left Course 20 Wks |  | 2 |  |  |  |  |  |  |  |  |  |  |  |  |  | Wednesday
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Thursday
 |  | Left Course 30 Wks |  | 1 |  |  |  |  |  |  |  |  |  |  |  |  |  | Friday
 |  | On Course |  | 14
 | Number | Day | Start | Team | 10 Weeks | 20 Weeks | 30 Weeks | End
 | 1 | Monday | 2012-03-05 00:00:00 | Green | 2012-05-14 00:00:00 | 2012-07-23 00:00:00 | 2012-10-01 00:00:00 | 2012-05-12 00:00:00 |  |  |  |  |  | 1 | FALSE | FALSE
 | 2 | Monday | 2012-03-05 00:00:00 | Green | 2012-06-03 00:00:00 | 2012-09-02 00:00:00 | 2013-03-04 00:00:00 | 2012-03-09 00:00:00 |  |  |  |  |  | 1 | FALSE | FALSE
 | 3 | Monday | 2012-03-05 00:00:00 | Blue | 2012-06-03 00:00:00 | 2012-09-02 00:00:00 | 2013-03-04 00:00:00 |  |  |  |  |  |  | 0 | FALSE | FALSE
 | 4 | Monday | 2012-03-05 00:00:00 | Red | 2012-06-03 00:00:00 | 2012-09-02 00:00:00 | 2013-03-04 00:00:00 | 2012-09-01 00:00:00 |  |  |  |  |  | 0 | TRUE | FALSE
 | 5 | Monday | 2012-03-05 00:00:00 | Red | 2012-06-03 00:00:00 | 2012-09-02 00:00:00 | 2013-03-04 00:00:00 |  |  |  |  |  |  | 0 | FALSE | FALSE
 | 6 | Wednesday | 2012-03-07 00:00:00 | Green | 2012-06-05 00:00:00 | 2012-09-04 00:00:00 | 2013-03-06 00:00:00 | 2012-10-05 00:00:00 |  |  |  |  |  | 0 | FALSE | TRUE
 | 7 | Wednesday | 2012-03-07 00:00:00 | Red | 2012-06-05 00:00:00 | 2012-09-04 00:00:00 | 2013-03-06 00:00:00 |  |  |  |  |  |  | 0 | FALSE | FALSE
 | 8 | Wednesday | 2012-03-07 00:00:00 | Red | 2012-06-05 00:00:00 | 2012-09-04 00:00:00 | 2013-03-06 00:00:00 |  |  |  |  |  |  | 0 | FALSE | FALSE
 | 9 | Wednesday | 2012-03-07 00:00:00 | Green | 2012-06-05 00:00:00 | 2012-09-04 00:00:00 | 2013-03-06 00:00:00 | 2012-04-03 00:00:00 |  |  |  |  |  | 1 | FALSE | FALSE
 | 10 | Wednesday | 2012-03-07 00:00:00 | Green | 2012-06-05 00:00:00 | 2012-09-04 00:00:00 | 2013-03-06 00:00:00 |  |  |  |  |  |  | 0 | FALSE | FALSE
 | 11 | Monday | 2012-03-12 00:00:00 | Green | 2012-06-10 00:00:00 | 2012-09-09 00:00:00 | 2013-03-11 00:00:00 |  |  |  |  |  |  | 0 | FALSE | FALSE
 | 12 | Monday | 2012-03-12 00:00:00 | Blue | 2012-06-10 00:00:00 | 2012-09-09 00:00:00 | 2013-03-11 00:00:00 |  |  |  |  |  |  | 0 | FALSE | FALSE
 | 13 | Monday | 2012-03-12 00:00:00 | Blue | 2012-06-10 00:00:00 | 2012-09-09 00:00:00 | 2013-03-11 00:00:00 | 2012-09-06 00:00:00 |  |  |  |  |  | 0 | TRUE | FALSE
 | 14 | Monday | 2012-03-12 00:00:00 | Blue | 2012-06-10 00:00:00 | 2012-09-09 00:00:00 | 2013-03-11 00:00:00 |  |  |  |  |  |  | 0 | FALSE | FALSE
 | 15 | Monday | 2012-03-12 00:00:00 | Red | 2012-06-10 00:00:00 | 2012-09-09 00:00:00 | 2013-03-11 00:00:00 |  |  |  |  |  |  | 0 | FALSE | FALSE
 | 16 | Wednesday | 2012-03-14 00:00:00 | Green | 2012-06-12 00:00:00 | 2012-09-11 00:00:00 | 2013-03-13 00:00:00 |  |  |  |  |  |  | 0 | FALSE | FALSE
 | 17 | Wednesday | 2012-03-14 00:00:00 | Green | 2012-06-12 00:00:00 | 2012-09-11 00:00:00 | 2013-03-13 00:00:00 |  |  |  |  |  |  | 0 | FALSE | FALSE
 | 18 | Wednesday | 2012-03-14 00:00:00 | Green | 2012-06-12 00:00:00 | 2012-09-11 00:00:00 | 2013-03-13 00:00:00 |  |  |  |  |  |  | 0 | FALSE | FALSE
 | 19 | Wednesday | 2012-03-14 00:00:00 | Red | 2012-06-12 00:00:00 | 2012-09-11 00:00:00 | 2013-03-13 00:00:00 |  |  |  |  |  |  | 0 | FALSE | FALSE
 | 20 | Wednesday | 2012-03-14 00:00:00 | Blue | 2012-06-12 00:00:00 | 2012-09-11 00:00:00 | 2013-03-13 00:00:00 |  |  |  |  |  |  | 0 | FALSE | FALSE