Spreadsheet: 711772d1609896857-formula-that-calculates-the-number-of-workweeks-sent-out-draft-class-list
Sheet: Combined Dataremove pre11-13-14

EMP_LastName | EMP_FirstName | ORIG_HIRE_DT | ORIG TERM ASSUMED | HIRE_DT | TERMINATION_DT | SOL 1 11/13/14 | SOL 2 11/13/15 | SOL 3 11/13/17 | [NAME]  Count 1 | [NAME]  Count 2 | [NAME]  Count 3
 | Marvin | 2016-04-04 00:00:00 |  | 2016-04-04 00:00:00 | 2018-09-10 23:59:00 | 2014-11-13 00:00:00 | 2015-11-13 00:00:00 | 2017-11-13 00:00:00
 | Ramon | 2019-01-23 00:00:00 |  | 2019-01-23 00:00:00 | 2019-12-20 23:59:00 | 2014-11-13 00:00:00 | 2015-11-13 00:00:00 | 2017-11-13 00:00:00
 | [NAME] | 2019-07-22 00:00:00 |  | 2019-07-22 00:00:00 | 2021-01-08 00:00:00 | 2014-11-13 00:00:00 | 2015-11-13 00:00:00 | 2017-11-13 00:00:00
 | [NAME] | 2010-06-07 00:00:00 | 2017-10-02 00:00:00 | 2019-09-23 00:00:00 | 2019-12-20 23:59:00 | 2014-11-13 00:00:00 | 2015-11-13 00:00:00 | 2017-11-13 00:00:00
 | Perceus | 2010-12-21 00:00:00 |  | 2010-12-21 00:00:00 | 2021-01-08 00:00:00 | 2014-11-13 00:00:00 | 2015-11-13 00:00:00 | 2017-11-13 00:00:00
 | Ioapo | 2002-01-20 00:00:00 |  | 2002-01-20 00:00:00 | 2021-01-08 00:00:00 | 2014-11-13 00:00:00 | 2015-11-13 00:00:00 | 2017-11-13 00:00:00
 | Alhamzah | 2016-04-26 00:00:00 |  | 2016-04-26 00:00:00 | 2016-04-30 23:59:00 | 2014-11-13 00:00:00 | 2015-11-13 00:00:00 | 2017-11-13 00:00:00
 | [NAME] | 2018-01-30 00:00:00 |  | 2018-01-30 00:00:00 | 2018-08-20 23:59:00 | 2014-11-13 00:00:00 | 2015-11-13 00:00:00 | 2017-11-13 00:00:00
 | [NAME] | 2018-04-18 00:00:00 |  | 2018-04-18 00:00:00 | 2018-12-09 23:59:00 | 2014-11-13 00:00:00 | 2015-11-13 00:00:00 | 2017-11-13 00:00:00
 | Javier | 2017-07-05 00:00:00 |  | 2017-07-05 00:00:00 | 2018-12-09 23:59:00 | 2014-11-13 00:00:00 | 2015-11-13 00:00:00 | 2017-11-13 00:00:00
 | [NAME] | 2020-01-06 00:00:00 | 2020-04-27 00:00:00 | 2020-06-26 00:00:00 | 2020-04-27 23:59:00 | 2014-11-13 00:00:00 | 2015-11-13 00:00:00 | 2017-11-13 00:00:00
 | Gerardo | 2001-07-22 00:00:00 |  | 2001-07-22 00:00:00 | 2016-05-02 23:59:00 | 2014-11-13 00:00:00 | 2015-11-13 00:00:00 | 2017-11-13 00:00:00
 | Gerardo | 2006-05-15 00:00:00 |  | 2006-05-15 00:00:00 | 2021-01-08 00:00:00 | 2014-11-13 00:00:00 | 2015-11-13 00:00:00 | 2017-11-13 00:00:00
 | Armando | 2010-12-21 00:00:00 |  | 2010-12-21 00:00:00 | 2021-01-08 00:00:00 | 2014-11-13 00:00:00 | 2015-11-13 00:00:00 | 2017-11-13 00:00:00
 | [NAME] | 2015-12-08 00:00:00 |  | 2015-12-08 00:00:00 | 2019-02-15 23:59:00 | 2014-11-13 00:00:00 | 2015-11-13 00:00:00 | 2017-11-13 00:00:00
 | Amanda | 2017-09-06 00:00:00 |  | 2017-09-06 00:00:00 | 2018-03-25 23:59:00 | 2014-11-13 00:00:00 | 2015-11-13 00:00:00 | 2017-11-13 00:00:00
 | [NAME] | 2003-11-10 00:00:00 |  | 2003-11-10 00:00:00 | 2021-01-08 00:00:00 | 2014-11-13 00:00:00 | 2015-11-13 00:00:00 | 2017-11-13 00:00:00
 | [NAME] | 2014-08-07 00:00:00 |  | 2014-08-07 00:00:00 | 2016-08-03 23:59:00 | 2014-11-13 00:00:00 | 2015-11-13 00:00:00 | 2017-11-13 00:00:00
 | [NAME] | 2015-12-14 00:00:00 |  | 2015-12-14 00:00:00 | 2018-12-09 23:59:00 | 2014-11-13 00:00:00 | 2015-11-13 00:00:00 | 2017-11-13 00:00:00
 | [NAME] | 2008-04-21 00:00:00 |  | 2008-04-21 00:00:00 | 2015-05-07 23:59:00 | 2014-11-13 00:00:00 | 2015-11-13 00:00:00 | 2017-11-13 00:00:00
 | [NAME] | 2020-01-13 00:00:00 |  | 2020-01-13 00:00:00 | 2021-01-08 00:00:00 | 2014-11-13 00:00:00 | 2015-11-13 00:00:00 | 2017-11-13 00:00:00
 | Enrique | 2019-02-04 00:00:00 |  | 2019-02-04 00:00:00 | 2021-01-08 00:00:00 | 2014-11-13 00:00:00 | 2015-11-13 00:00:00 | 2017-11-13 00:00:00
 | [NAME] | 2020-03-05 00:00:00 | 2020-04-27 00:00:00 | 2020-06-29 00:00:00 | 2020-04-27 23:59:00 | 2014-11-13 00:00:00 | 2015-11-13 00:00:00 | 2017-11-13 00:00:00