Spreadsheet: 455778d1460489649-if-statement-conditional-formating-testing-need-help-help-training
Sheet: 4-6-2016

Person ID | CoDscrp | Company | Name | Division | Dept | Location | Job Title | Supervisor | Original Hire | 30 days After Original Hire | Training 1 2016 | training 2 2016 | training 3 2016 | training 1 2015 | training 2 2015 | training 3 2015 | training 4 2015 | Training 1 2016 | training 2 2016 | training 3 2016 | training 1 2015 | training 2 2015 | training 3 2015 | training 4 2015 | Training 1 2016 | training 2 2016 | training 3 2016 | training 1 2015 | training 2 2015 | training 3 2015 | training 4 2015 | New Employee Training Complete Timely
 |  |  | [NAME], [NAME] |  |  |  |  |  | 2001-05-29 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016-06-06 00:00:00 | 2016-06-06 00:00:00 |  | 2015-07-06 00:00:00
 |  |  | [NAME], [NAME] |  |  |  |  |  | 2015-12-28 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2015-03-02 00:00:00 |  |  |  |  | 2015-07-07 00:00:00
 |  |  | [NAME], [NAME] |  |  |  |  |  | 2015-12-29 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016-04-03 00:00:00 |  |  |  | 2015-07-08 00:00:00
 |  |  | [NAME], [NAME] |  |  |  |  |  | 2015-12-30 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2016-07-07 00:00:00 | 2016-01-01 00:00:00 |  | 2015-07-09 00:00:00
 |  |  | [NAME], [NAME] |  |  |  |  |  | 2015-12-31 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2015-02-02 00:00:00 |  |  |  | 2015-07-10 00:00:00
 |  |  | [NAME], [NAME] |  |  |  |  |  | 2016-01-01 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2015-01-01 00:00:00 |  |  |  | 2015-07-11 00:00:00
 |  |  | [NAME], [NAME] |  |  |  |  |  | 2016-01-02 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2015-07-12 00:00:00
 |  |  | [NAME], [NAME] |  |  |  |  |  | 2016-01-03 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2015-07-13 00:00:00
 |  |  | [NAME], [NAME] |  |  |  |  |  | 2016-01-04 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2015-07-14 00:00:00
 |  |  | [NAME], [NAME] |  |  |  |  |  | 2016-01-05 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2015-07-15 00:00:00
 |  |  | [NAME], [NAME] |  |  |  |  |  | 7/30/2007 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2015-07-16 00:00:00
 |  |  | [NAME], [NAME] |  |  |  |  |  | 9/7/2004 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2015-07-17 00:00:00
 |  |  | [NAME], [NAME] |  |  |  |  |  | 2/25/2013
 |  |  | [NAME], [NAME] |  |  |  |  |  | 2015-11-09 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2015-07-07 00:00:00
 |  |  | [NAME], [NAME] |  |  |  |  |  | 2005-01-18 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2015-08-11 00:00:00
 |  |  | [NAME], [NAME] |  |  |  |  |  | 2005-01-19 00:00:00
 |  |  | [NAME], [NAME] |  |  |  |  |  | 2005-01-20 00:00:00
 |  |  | [NAME], [NAME] |  |  |  |  |  | 2005-01-21 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2015-03-02 00:00:00
 |  |  | [NAME], [NAME] |  |  |  |  |  | 2005-01-22 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2015-03-03 00:00:00
 |  |  | [NAME], [NAME] |  |  |  |  |  | 2005-01-23 00:00:00 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2015-11-11 00:00:00
 |  |  | [NAME], [NAME] |  |  |  |  |  | 2015-05-30 00:00:00
 |  |  | [NAME], [NAME] |  |  |  |  |  | 2015-05-31 00:00:00
 |  |  | [NAME], [NAME] |  |  |  |  |  | 2015-06-01 00:00:00
 |  |  | [NAME], [NAME] |  |  |  |  |  | 2015-06-02 00:00:00
 |  |  | [NAME], [NAME] |  |  |  |  |  | 2015-06-03 00:00:00
 |  |  | [NAME], [NAME] |  |  |  |  |  | 2015-06-04 00:00:00
 |  |  | [NAME], [NAME] |  |  |  |  |  | 2015-06-05 00:00:00
 |  |  | [NAME], [NAME] |  |  |  |  |  | 2015-06-06 00:00:00
 |  |  | [NAME], [NAME] |  |  |  |  |  | 2015-06-07 00:00:00
 |  |  | [NAME], [NAME] |  |  |  |  |  | 2015-06-08 00:00:00
 |  |  | [NAME], [NAME] |  |  |  |  |  | 2015-06-09 00:00:00
 |  |  | [NAME], [NAME] |  |  |  |  |  | 2015-06-10 00:00:00
 |  |  | [NAME], [NAME] |  |  |  |  |  | 7/2/1989
 |  |  | [NAME], [NAME] |  |  |  |  |  | 7/2/1990
 |  |  | [NAME], [NAME] |  |  |  |  |  | 7/2/1991
 |  |  | [NAME], [NAME] |  |  |  |  |  | 7/2/1992
 |  |  | [NAME], [NAME] |  |  |  |  |  | 7/2/1993
 |  |  | [NAME], [NAME] |  |  |  |  |  | 7/2/1994
 |  |  | [NAME], [NAME] |  |  |  |  |  | 7/2/1995
 |  |  | [NAME], [NAME] |  |  |  |  |  | 7/2/1996
 |  |  | [NAME], [NAME] |  |  |  |  |  | 7/2/1997
 |  |  | [NAME], [NAME] |  |  |  |  |  | 7/2/1998
 |  |  | [NAME], [NAME] |  |  |  |  |  | 7/2/1999
 |  |  | [NAME], [NAME] |  |  |  |  |  | 7/2/2000
 |  |  | [NAME], [NAME] |  |  |  |  |  | 7/2/2001
 |  |  | [NAME], [NAME] |  |  |  |  |  | 2015-08-03 00:00:00
 |  |  | [NAME], [NAME] |  |  |  |  |  | 10/9/2012
 |  |  | [NAME], [NAME] |  |  |  |  |  | 5/11/2009
 |  |  | [NAME], [NAME] |  |  |  |  |  | 3/7/2011
 |  |  | [NAME], [NAME] |  |  |  |  |  | 5/18/2015
 |  |  | [NAME], [NAME] |  |  |  |  |  | 5/18/2016
 |  |  | [NAME], [NAME] |  |  |  |  |  | 5/18/2017
 |  |  | [NAME], [NAME] |  |  |  |  |  | 5/18/2018
 |  |  | [NAME], [NAME] |  |  |  |  |  | 5/18/2019
 |  |  | [NAME], [NAME] |  |  |  |  |  | 5/18/2020
 |  |  | [NAME], [NAME] |  |  |  |  |  | 5/18/2021
 |  |  | [NAME], [NAME] |  |  |  |  |  | 5/18/2022
 |  |  | [NAME], [NAME] |  |  |  |  |  | 5/18/2023
 |  |  | [NAME], [NAME] |  |  |  |  |  | 5/18/2024
 |  |  | [NAME], [NAME] |  |  |  |  |  | 3/6/2006
 |  |  | [NAME], [NAME] |  |  |  |  |  | 2015-01-26 00:00:00
 |  |  | [NAME], [NAME] |  |  |  |  |  | 6/23/1997
 |  |  | [NAME], [NAME] |  |  |  |  |  | 5/31/2011
 |  |  | [NAME], [NAME] |  |  |  |  |  | 5/31/2012
 |  |  | [NAME], [NAME] |  |  |  |  |  | 5/31/2013
 |  |  | [NAME], [NAME] |  |  |  |  |  | 7/31/2003
 |  |  | [NAME], [NAME] |  |  |  |  |  | 3/12/2014
 |  |  | [NAME], [NAME] |  |  |  |  |  | 6/9/1997
 |  |  | [NAME], [NAME] |  |  |  |  |  | 2015-11-16 00:00:00
 |  |  | [NAME], [NAME] |  |  |  |  |  | 8/18/1997
 |  |  | [NAME], [NAME] |  |  |  |  |  | 4/15/2002
 |  |  | [NAME], [NAME] |  |  |  |  |  | 9/12/2011
 |  |  | [NAME], [NAME] |  |  |  |  |  | 7/12/1999
 |  |  | [NAME], [NAME] |  |  |  |  |  | 7/12/2000
 |  |  | [NAME], [NAME] |  |  |  |  |  | 7/12/2001
 |  |  | [NAME], [NAME] |  |  |  |  |  | 11/13/2001
 |  |  | [NAME], [NAME] |  |  |  |  |  | 11/13/2002
 |  |  | [NAME], [NAME] |  |  |  |  |  | 11/13/2003
 |  |  | [NAME], [NAME] |  |  |  |  |  | 11/13/2004
 |  |  | [NAME], [NAME] |  |  |  |  |  | 11/13/2005
 |  |  | [NAME], [NAME] |  |  |  |  |  | 1/22/2007
 |  |  | [NAME], [NAME] |  |  |  |  |  | 6/16/1997
 |  |  | [NAME], [NAME] |  |  |  |  |  | 6/16/1998
 |  |  | [NAME], [NAME] |  |  |  |  |  | 6/16/1999
 |  |  | [NAME], [NAME] |  |  |  |  |  | 6/16/2000
 |  |  | [NAME], [NAME] |  |  |  |  |  | 6/16/2001
 |  |  | [NAME], [NAME] |  |  |  |  |  | 6/16/2002
 |  |  | [NAME], [NAME] |  |  |  |  |  | 6/16/2003
 |  |  | [NAME], [NAME] |  |  |  |  |  | 12/9/2008
 |  |  | [NAME], [NAME] |  |  |  |  |  | 2/23/1998
 |  |  | [NAME], [NAME] |  |  |  |  |  | 1/29/2007
 |  |  | [NAME], [NAME] |  |  |  |  |  | 11/22/2010
 |  |  | [NAME], [NAME] |  |  |  |  |  | 11/22/2011
 |  |  | [NAME], [NAME] |  |  |  |  |  | 11/22/2012
 |  |  | [NAME], [NAME] |  |  |  |  |  | 2013-11-12 00:00:00
 |  |  | [NAME], [NAME] |  |  |  |  |  | 2013-11-13 00:00:00
 |  |  | [NAME], [NAME] |  |  |  |  |  | 11/22/2015