Spreadsheet: 266518d1379640402-conditional-formatting-to-identify-expiration-dates-in-a-training-log-19-09-2013_excelforum_training-log-draft
Sheet: Formulas

Days Certification is good for: |  |  |  |  |  |  |  | 1095 | 365 | 1095 | 365 |  | 365 |  | 1095 | 365 |  |  | 1095 |  |  |  |  | 365 |  | 365 |  | 730 |  | 365 | 365 | 365 |  | 365 | 365 | 365 | 365 | 365 | 365 | 365 | 365 | 1095 |  | 365 | 365 |  | 365 |  | 365 | 365 | 730 |  | 1095 |  |  |  | 365 |  | 365 | 365 | 365 | 365 |  | 365 | 365 |  |  |  |  |  |  | 365 |  | 365 |  |  | 365 | 365 | 365 |  | 365 |  | 1095 | 1095 | 365 | 1095 |  |  | 365 | 365 |  |  |  |  | 365 |  |  |  |  |  |  |  |  |  |  |  |  | 365 |  | 365 |  | 1095 | 365 | 1095 |  | 365 |  | 365 |  |  |  |  |  |  |  | 365 |  |  | 365 |  |  |  | 365 |  | 365
Employee Number | Last Name | First Name | Craft | A&P New Hire | Site Specific Orientation | Access to medical records | OSHA 30 | Aerial Lift | AISC Sophisticated Paint Endorsement | Articulating Boom Lift | Asbestos Awareness | [NAME] | Assured Grounding | AZZ Galvanizing Course | Backhoe | Back Safety | Basic Communication Skills | Blue Print Reading | Boom Lift | Brazing Test for Certification and Recertification | CAMT - Job Instruction | CAMT - Job Relations | CAMT - Job Safety | Cold Weather | Combustible Gas Detector | Confined Spaces | CPMI Planning | CPR/FA/AED  [NAME] | Cost Reduction Technology Test | Crane Safety | DBI Rescue Positioning Device | Defensive Driving | [NAME] | Driving Safely | Drug & Alcohol Policy | Effects of Weather | Electrical Safety | Electrical Safety Arc Flash/Blast | Emergency Response | Ergonomical Material Handling | Excavation and Trenching | Excavator | Excel Contractor Electrical | Eye and Face Potection | Fall Protection | Fall Protection Inspection | Fall Protection Trauma Straps | Field Managers Training | Fire Prevention / Extinguisher | [NAME] | Flagger Certification | Flowguard CPVC | Forklift            RT  Warehouse | Fuseal Acid Waste | Gas Piping Systems | Gauge Calibration | GHS 2012 | Grizzly Fall Protection Cart | Hand and Power Tools | Hand Safety | HAZCOM | [NAME] | Healthcare | Hearing Conservation | Heat Stress | Hilti | Housekeeping | Infection Control Risk Assessment | Install Procedures | International Plumbing Code | ISO | Incident Injury Reporting | Infection Control risk Assessment | Job Hazard Analysis | Job Candidate Profile | KVA Heat Trace Training | Ladder Safety | Lasers | Lead Awareness | Listening Skills | LOTO | LXT Purewater Systems | Med Gas Install / Brazer Certification Training | Mini-Ex | Near Miss Reporting | New Hire Orientation | OSHA 10 | OSHA 500 | Overhead Hazards | Pipe Testing Procedures | Plumbing First Yr. | Plumbing 2nd Yr. | Plumbing 3rd Yr. | Post Anchor Installation | PPE | Pressure Testing Procedures | [NAME] | Project Management - Schedule of Values | Project Material Handling | Propress | QC Inspector Training | Qualified Crane Signal Person | Qualified Rigging and [NAME] | Respiratory Protection | [NAME] | Quality Control | Reasonable Suspcion | Respirator Use and Care | RK Fundamentals | [NAME] | Signs | Scissor Lift | Signals - Crane , Forklift & Excavator | Skidsteer | Slips, Trips, [NAME] | Slips/TripsFalls | Specialty Safety Training | Spills, Leak Prevention & Response | Supervisor Safety Program | Time Management | Torque Wrench | TracPipe | Training within Industry | Union Organization Issues / Union Free Management | Uponor Logic Plumbing Cert | Vehicle Operations | [NAME] | [NAME] | Voluntary Respirator [NAME] D | VPP Field Training | [NAME] for Field Managers | VPP Office Training | Walking Working Surfaces | Welding Certification | Welding Safety | Writing Skills Workshop