Spreadsheet: 233669d1367885863-changing-colour-in-cells-date-dependant-drivers-bfm-licence-medical-and-training-register-play
Sheet: Drivers Info

Drivers [NAME] |  |  |  |  |  |  |  |  |  |  |  | Today's Date
EMPLOYEE | DOB | CURRENT AGE | DATE MEDICAL CONDUCTED | Mths | DUE FOR MEDICAL | DRIVERS LICENCE No. | STATE OF ISSUE & EXPIRY DATE | DATE BFM UNDERTAKEN | START DATE | PERIOD OF EMPLOYMENT
 | 1950-08-30 00:00:00 |  | 2012-08-08 00:00:00 | 12 |  |  | QLD -- 30-08-2014 | 2009-06-05 00:00:00 | 2013-02-13 00:00:00
 | 1970-03-06 00:00:00 |  | 2012-10-02 00:00:00 | 12 |  |  | QLD -- 29-11-2013 | 2009-05-19 00:00:00 | SUBBY
 | 1969-04-25 00:00:00 |  | 2013-04-12 00:00:00 | 36 |  |  | QLD -- 19-08-2015 | 2009-11-11 00:00:00 | 2013-04-09 00:00:00
 | 1958-07-10 00:00:00 |  | 2012-10-30 00:00:00 | 12 |  |  | QLD -- 10-07-2017 | 2010-09-01 00:00:00 | 2010-09-02 00:00:00
 | 1975-03-10 00:00:00 |  | 2011-11-07 00:00:00 | 36 |  |  | QLD -- 20-03-2015 | 2008-09-25 00:00:00 | 2010-01-12 00:00:00
 | 1973-06-02 00:00:00 |  | 2010-01-21 00:00:00 | 60 | 2015-01-15 00:00:00 |  | QLD -- 07-10-2016 | 2010-01-21 00:00:00 | 2010-01-19 00:00:00
 | 1966-01-30 00:00:00 |  | 2012-12-04 00:00:00 | 36 |  |  | QLD - 30-01-2014 | 2011-06-16 00:00:00 | 2012-09-29 00:00:00
 | 1974-07-08 00:00:00 |  | 2012-05-03 00:00:00 | 36 |  |  | QLD - 05-06-2014 | 2009-02-28 00:00:00 | 2011-07-28 00:00:00
 | 1956-09-05 00:00:00 |  | 2012-06-01 00:00:00 | 12 |  |  | QLD -- 18-11-2017 | 2012-06-02 00:00:00 | 2011-11-16 00:00:00
 | 1951-04-06 00:00:00 |  | 2013-04-26 00:00:00 | 12 |  |  | QLD -- 13-03-2016 | 2009-06-23 00:00:00 | 2009-06-04 00:00:00
 | 1973-09-08 00:00:00 |  | 2009-06-06 00:00:00 | 36 | [NAME] |  | QLD -- 03-10-2013 | 2009-06-26 00:00:00 | 2011-04-27 00:00:00
 | 1957-07-03 00:00:00 |  | 2010-09-18 00:00:00 | 12 | 2013-05-08 00:00:00 |  | QLD -- 25-07-2016 | 2008-09-17 00:00:00 | SUBBY
 | 1971-08-16 00:00:00 |  | 2013-05-24 00:00:00 | 36 |  |  | QLD -- 05-02-2013 | 2008-09-19 00:00:00 | 2010-06-05 00:00:00
 | 1971-12-10 00:00:00 |  | 2011-08-01 00:00:00 | 36 |  |  | QLD -- 23-02-2014 | 2011-08-25 00:00:00 | 2011-10-13 00:00:00
 | 1956-05-22 00:00:00 |  | 2012-11-06 00:00:00 | 12 |  |  | QLD - 22-05-2014 | 2009-09-23 00:00:00 | 2010-11-10 00:00:00
 | 1951-06-27 00:00:00 |  | 2013-03-13 00:00:00 | 12 |  |  | QLD - 24-05-2016 | 2008-11-12 00:00:00 | 2011-11-13 00:00:00
 | 1966-04-02 00:00:00 |  | 2012-06-18 00:00:00 | 36 |  |  | QLD - 06-10-2013 | 2009-02-25 00:00:00 | 2012-09-14 00:00:00
 | 1955-02-11 00:00:00 |  | 2012-06-12 00:00:00 | 12 |  |  | QLD -- 02-12-2016 | 2009-05-06 00:00:00 | 2008-05-23 00:00:00
 | 1961-02-12 00:00:00 |  | 2009-02-12 00:00:00 | 12 | 2010-02-12 00:00:00 |  |  | 2009-02-28 00:00:00 | 2003-07-01 00:00:00
 | 1969-01-04 00:00:00 |  | 2011-07-12 00:00:00 | 36 |  |  | QLD -- 26-10-2014 | 2009-10-08 00:00:00 | 2012-06-29 00:00:00
 | 1965-10-09 00:00:00 |  | 2011-04-04 00:00:00 | 36 |  |  | QLD -- 09-10-2017 |  | 2012-12-07 00:00:00
 | 1972-11-28 00:00:00 |  | 2012-11-16 00:00:00 | 36 |  |  | QLD -- 15-09-2015 | 2009-09-22 00:00:00 | 2011-07-06 00:00:00
 | 1977-02-16 00:00:00 |  | 2013-04-09 00:00:00 | 60 |  |  | QLD -- 05-07-2016 | 2013-04-11 00:00:00 | SUBBY
 |  |  | Legend
 |  |  | Due this year
 |  |  | Due within a month
 |  |  | OVERDUE