Spreadsheet: 144653d1331079415-conditional-formatting-for-due-dates-client-ur-master
Sheet: Tray

Name | System # | Admit Date | 6 mos | 6mos due | Rev date | Annual | UR
[NAME], [NAME] | 8951201 | 2011-03-29 00:00:00 | 2011-03-29 00:00:00 | 2011-09-29 00:00:00 | 2011-03-29 00:00:00 | 2011-04-12 00:00:00 | 2011-09-29 00:00:00
[NAME], [NAME] | 11553701 | 2011-05-23 00:00:00 | 2011-05-23 00:00:00 | 2011-11-23 00:00:00 | 2011-05-23 00:00:00 | due | 2011-11-23 00:00:00
[NAME], [NAME] | 100169761 | 2011-01-03 00:00:00 | 2011-01-10 00:00:00 | 2011-07-10 00:00:00 | 2011-01-10 00:00:00 | 2011-01-03 00:00:00 | 2011-07-10 00:00:00
[NAME] | 100212611 | 2009-07-22 00:00:00 | 2011-01-25 00:00:00 | 2011-07-25 00:00:00 | 2010-08-03 00:00:00 | 2010-07-20 00:00:00 | 2011-07-25 00:00:00
[NAME], [NAME] | 19951001 | 2011-04-12 00:00:00 | 2011-04-12 00:00:00 | 2011-10-12 00:00:00 | 2011-04-12 00:00:00 |  | 2011-07-25 00:00:00
[NAME] | 9548801 | 2010-05-25 00:00:00 | 2011-05-10 00:00:00 | 2011-11-10 00:00:00 | 2010-05-25 00:00:00 | 2010-07-26 00:00:00 | 2011-11-10 00:00:00 | o/d
[NAME], [NAME] | 10869001 | 2011-03-23 00:00:00 | 2011-03-23 00:00:00 | 2011-09-23 00:00:00 | 2011-03-23 00:00:00 |  | 2011-09-23 00:00:00
Gladtzel, [NAME] | 10815701 | 2011-01-19 00:00:00 | 2011-01-26 00:00:00 | 2011-07-26 00:00:00 | 2011-01-26 00:00:00 | 2011-01-19 00:00:00 | 2011-07-11 00:00:00
Guerra, Beverly | 1524401 | 2010-09-13 00:00:00 | 2011-03-16 00:00:00 | 2011-09-13 00:00:00 | 2011-09-13 00:00:00 | 2011-05-16 00:00:00 | 2011-09-13 00:00:00 | 0/d
Hildebrand ,[NAME] | 20895401 | 2010-08-02 00:00:00 | 2011-02-01 00:00:00 | 2011-08-01 00:00:00 | 2010-08-02 00:00:00 | 2011-02-07 00:00:00 | 2011-08-01 00:00:00 | o/d
Kuhnly [NAME] | 417201 | 2009-07-28 00:00:00 | 2011-04-25 00:00:00 | 2011-08-05 00:00:00 | 2010-08-05 00:00:00 | 2010-09-13 00:00:00 | 2011-08-05 00:00:00 | 0/d
[NAME] | 16667702 | 2010-06-07 00:00:00 | 2010-12-06 00:00:00 | 2011-06-06 00:00:00 | 2010-06-21 00:00:00 | 2010-06-07 00:00:00 | 2011-06-06 00:00:00
[NAME] | 15729501 | 2011-05-31 00:00:00 | 2011-05-31 00:00:00 | 2011-11-30 00:00:00 | 2011-05-31 00:00:00 |  | 2011-11-30 00:00:00
[NAME], [NAME] | 200030862 | 2011-03-29 00:00:00 | 2011-03-29 00:00:00 | 2011-09-29 00:00:00 | 2011-03-29 00:00:00 | 2010-06-02 00:00:00 | 2011-09-29 00:00:00
Salaam, Nima | 200052700 | 2011-05-17 00:00:00 | 2011-06-01 00:00:00 | 2011-12-01 00:00:00 | 2011-06-01 00:00:00 | 2011-05-23 00:00:00 | 2011-12-01 00:00:00
[NAME], [NAME] | 5469701 | 2011-04-26 00:00:00 | 2011-04-26 00:00:00 | 2011-10-26 00:00:00 | 2011-04-26 00:00:00 |  | 2011-10-26 00:00:00
Tonnesen, Lydia | 100044332 | 2011-04-26 00:00:00 | 2011-04-26 00:00:00 | 2011-10-26 00:00:00 | 2011-04-26 00:00:00 |  | 2011-10-26 00:00:00
Wells, [NAME] | 200055165 | 2011-06-20 00:00:00 | 2011-07-07 00:00:00 | 2012-01-07 00:00:00 | 2011-07-07 00:00:00 | 2011-06-20 00:00:00 | 2012-01-07 00:00:00
Winfield, [NAME] | 200026776 | 2010-10-11 00:00:00 | 2011-04-11 00:00:00 | 2011-10-11 00:00:00 | 2010-10-19 00:00:00 | 2010-10-11 00:00:00 | 2011-10-11 00:00:00 | o/d
[NAME] | 3552501 | 2011-06-28 00:00:00 | 2011-06-28 00:00:00 | 2011-12-28 00:00:00 | 2011-06-28 00:00:00 | 2011-05-10 00:00:00 | 2011-12-28 00:00:00