Spreadsheet: 825902d1681627671-counting-cells-based-on-dates-v-todays-date-book2
Sheet: Sheet1

 |  |  |  | Completed
 |  |  |  | Required
 |  |  |  | Expired/ing <>1m |  |  |  | Needs to count no of dates in column F which are 30 days before todays date in cell [NAME] (or imbedded in formula) or = today's date or have gone past it - basically, expiring in 30 days or have expired
 |  |  |  | Planned <6m-1m |  |  |  | Needs to count column f dates occuring within next 6 months but not within next 30 days
 |  |  |  | Planned >6m
 |  |  |  | Desirable
 |  |  |  | n/a
 |  |  |  | TBC
 |  |  |  | Training LM |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME] | [NAME]
 |  |  |  | Emp NO. |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 166977 | 160267 | 160270 | 160275 | 160268 | 160272 | 168567 | 169287
 |  |  |  | Role |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hygiene operative | Security Officer | Security Officer | Security Officer | Security Officer | Security Officer | Security Officer | Security Officer
 |  |  | Renewal |  | [NAME] | [NAME] | Mark |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | Antony Brunt | [NAME] | [NAME] | [NAME] | Eliana Hague | Todor Yordanov | [NAME]
 | Mandatory   Induction | Ethics Human Rights |  |  | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed
 |  | Modern Slavery |  |  | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed
 |  | Data Protection GDPR |  |  | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed
 |  | Site familiarity |  |  | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed
 | Management  Induction | The Digital Passport
 |  | Managing our way (MOW) |  |  | 2023-04-16 00:00:00
 | Academy | Commercial Awareness |  |  | 2023-04-13 00:00:00 | 2023-05-05 00:00:00 | 2023-04-10 00:00:00
 |  | Customer
 |  | Finance |  |  | Completed | 2023-09-23 00:00:00 | 2023-07-03 00:00:00
 |  | People
 |  | SHEQ |  |  | Completed | Completed |  |  | Completed
 | Health and  Safety | Health and Safety (Operator Level) | 1Y |  | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed
 |  | Health and Safety (Supervisor Level) | 1Y |  | Completed | Completed | Completed |  | Completed
 |  | IOSHH Certificate | 5Y |  | Completed |  |  |  | Completed
 |  | NLAR/Safety First |  |  | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed
 |  | COVID-19 |  |  | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed
 |  | Add specific training |  |  | Required
 |  | Add specific training |  |  | Desirable
 |  | Add specific training |  |  | n/a
 | Operational /Functional Requirements | Confined Space AP |  |  | TBC
 |  | High Risk Mechanical SP
 |  | High Risk Mechanical AP
 |  | Electrical LV CP
 |  | Gas Safe RP | 3Y |  |  |  |  |  | Completed
 |  | Water System CP | 3Y |  |  |  |  |  | Completed
 |  | Water Controlling Manager | 3Y |  |  |  |  |  | Completed
 |  | F-Gas Controlling Manager
 |  | F-Gas CP | 3Y |  |  |  |  |  | Completed
 |  | [NAME]
 |  | High Risk Mechanical Training
 |  | LV Electrical training
 |  | Management of Cooling Towers [NAME] | 3Y |  | Completed |  |  |  | Completed
 |  | [NAME] of L8
 |  | F-Gas Cat 1 Training
 |  | BOAS M
 |  | BOAS O
 |  | IPAF
 |  | Asbestos
 |  | COSHH | 1Y |  | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed
 |  | SOPs | 1Y |  | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed
 |  | RAMS | 1Y |  | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed | Completed
 |  | Data Protection GDPR/CyberSecurity | 1Y |  | Completed |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Completed | Completed | Completed | Completed | Completed | Completed | Completed |  | Completed
 |  | DSE | 1Y |  | Completed | Completed |  |  | Completed |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Completed | Completed | Completed | Completed | Completed | Completed | Completed
 |  | See It, Sort It, Report It | 1Y |  | Completed | Completed |  |  | Completed |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Completed | Completed | Completed | Completed | Completed | Completed | Completed
 |  | Fire Safety | 1Y |  | Completed | Completed |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Completed | Completed | Completed | Completed | Completed | Completed | Completed
 |  | Drugs and Alcohol | 1Y |  | Completed | Completed |  |  | Completed |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Completed | Completed | Completed | Completed | Completed | Completed | Completed
 |  | Winter Driving | 1Y |  | Completed |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Completed | Completed | Completed | Completed | Completed | Completed | Completed
 |  | COVID-19 | 1Y |  | Completed | Completed |  |  | Completed |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Completed | Completed | Completed | Completed | Completed | Completed | Completed
 |  | Mental Health Awarness | 1Y |  | Completed | Completed |  |  | Completed |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Completed | Completed | Completed | Completed | Completed | Completed | Completed
 |  | Confined Spaces | 1Y |  | Completed |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Completed | Completed | Completed | Completed | Completed | Completed | Completed
 |  | Control of Substances Hazardous | 1Y |  | Completed |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Completed | Completed | Completed | Completed | Completed | Completed | Completed
 |  | Contractor Management | 1Y |  | Completed |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Completed | Completed | Completed | Completed | Completed | Completed | Completed
 |  | Housekeeping | 1Y |  | Completed |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Completed | Completed | Completed | Completed | Completed | Completed | Completed
 |  | ACT Security E-Learning | 1Y |  | Completed |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Completed | Completed | Completed | Completed | Completed | Completed | Completed
 |  | ACTAwarness E-Learning | 1Y |  | Completed |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Completed | Completed | Completed | Completed | Completed | Completed | Completed
 |  | [NAME] | 3Y |  | Completed
 |  | Add training/competency
 |  | Add training/competency
 |  | Add training/competency
 |  | Add training/competency
 |  | Add training/competency
 |  | Add training/competency
 |  | Add training/competency
 |  | Add training/competency
 |  | Add training/competency
 |  | Add training/competency
 |  | Add training/competency
 |  | Add training/competency
 |  | Add training/competency
 | Systems  Training | [NAME] (for SAP Users) |  |  | Completed | Completed |  |  | Completed
 |  | Employee Onboarding Portal & SAP HR - Absence (for Line Mangaers) |  |  | Completed | Completed |  |  | Completed
 |  | Employee Onboarding Portal & SAP HR - adhoc query reporting (HR) |  |  | Completed | Completed |  |  | Completed
 |  | SIA Licensing - SAP HR (for employees administering SIA licensing) |  |  | Completed
 |  | Coupa R27 R&R (for employees who procure) |  |  | Completed | Completed
 |  | Coupa [NAME] (for employees who approve purchase requisitions) |  |  | Completed
 |  | SAP Finance WIP & Customer Sales Invoicing (for Contract Managers & Admin)
 |  | SAP Finance WIP & Customer Sales Invoicing (for Contract Managers & Admin) |  |  | Completed
 |  | [NAME] (for employees who travel as part of their role) |  |  | Completed