4. In cell G2, enter a formula without a function using structured references to determine the number of years since Alison Simoneau completed the HR training. The formula should subtract the value shown in the HR Training Year column from 2017 and should automatically fill to the range G3:31. Developer Help Design - Home Insert Page Layout Data Formulas Review View 12 A AutoSum Recently Financial Logical Text Date & Lookup & Math & More Used * Time Reference Time - Reference Trig" Functions Trig Functions Function Library E t con Define Name - inform Create from Selection Defined Names Tell me what you want to de Trace Precedents Show Forms a ce Dependents Error Creding - Remove Arrows Eve Formule Window Formula Auditing Name Man Manager - - X f IF(H2="Yes","Yes","No") Service Years Pay Rate Training Years since Year HR Training College Graduate Academic Technology Training Subject Leader Supervisor Online Tutoring Supervisor Eligible for Academie Technology Training Tuition Remission Completed Completed Completed Completed Completed Bible 2016 $ 25.00 2015 S 28.50 2017 $ 25.00 2016 2830 $ 25.00 2017 $ 18.00 2017 $ 28.50 2016 $ 20.00 2016 $ 20.00 2016 $ 25.00 2016 $ 25.00 2016 $ 25.00 2010 $ 25.00 2014 $ 25.00 2014 $ 20.00 2016 $ 28.50 2015 $ 22.50 2015 $25.00 2017 $ 22.50 2015 Staff Listing Completed Completed Completed Completed Type here to search