Please create a formula using COUNTIF to display TOTAL NUMBER OF EMPLOYEES WHO WERE HIRED AFTER ENTERED DATE

FORMULA SHOULD BE IN "No of Employees entered after the entered date" cell and you should be able to enter date into "enter a hire date below"

(use cell references/cell address instead of directly typing cell values for formula)

fx Inset Function | * e Detine Name - - Trace Precedents Show Formulas * Use in Formula AutoSum Recently Financial Logical Test Date & Lookup & Math & More Trace Dependents nor Checking Nyre Used Time Reference Tiig. Functions Manager Citate trom Selection Remove Allows evaluate Formula Function Library Defined Nannes Formula Auditing Calculate Now Watch Calculabon Calculate Sheet Window Options Calculation H19 C D E F G L M N 0 P Q B B 2521 R A 1 Employee ID 2 1 Date 1/1/2010 J Percent 990 H Bonus Criteria: Hired before Hired on or before but not before 1/1/2010) Hired after 3 4 5 Name Quick Search Results: Barnes Location Boston Accounter Title Account Rep Salary $41,804 1/1/2015 1/1/2015 5% 3% Boston Number of employees with the entered title 17 Total salary for the entered location $387,425 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 Employee ID 3824 4955 2521 4453 2967 2645 1268 4458 1370 2848 3996 4070 3099 2898 2611 1256 2009 4428 4545 1281 Name Location Adams Atlanta Akmatalieva Chicago Barnes Boston Crandell Deberard Chicago Doering Atlanta Forgan Atlanta Franklin Allanta Garbett Atlanta Gomez Boston Hartvigsen Boston Keone Chicago Laing Chicago Lenz Atlanta Nitz Chicago Peterson Atlanta Scholliek Alanla Selinger Boston Terriquez Chicago Unice Chicago Title Manager Account Rep Account Rep Manager Account Rep Account Rep Account Rep Account Rep Account Rep Account Rep Account Rep Account Rep Manager Account Rep Account Rep Account Rep Account Rep Account Rep Account Rep Account Rep Bonus Hire Date Salary Amount 10/14/2007 $ 68,750 S 6,188 11/3/2018 $ 49,575$ 1,487 B B/14/2014 $ 46,000 S 2,300 Enter a title below 3/9/2009 $ 75,800 S 6,822 Account Rep 12/4/2014 $ 46.795 $ 2.340 6/5/2014 $ 43,750 S 2.188 9/3/2015 $45.250 S 1,358 Enter a location below 7/19/2014 $ 47 240 S 2 362 Atlanta 9/18/2014 $ 47,835 S 2,392 10/15/2016 $ 46,725 S 1,402 2/18/2015 $ 45,000 $ 1.350 Enter a hire date below 4/3/2015 $45,125 S 1,354 1/17/2011 $ 65,500S 3,275 4/15/2012 $49.750 $ 2,488 8/15/2017 $ 41 000S 1.230 11/4/2015 $ 45,100 $ 1,353 7/14/2016 $ 39.750S 1,193 11/8/2016 $ 41,525 $ 1.246 4/15/2012 $ 49.750S 2,488 1/31/2014 $ 43,750 S 2,188 No. of employees hired after the entered date 27 28 29 30 31 32 33 34