2. Record a macro, QUESTION2, that will ask the user to input the hiring date (using inputbox function) and then calculate number of employees hired on or after that hiring date (e.g., user will input dates such as >=2/1/1995)? Set up criteria on Queries worksheet, and answer should be on Queries sheet in the cell indicated. Create macro button on Queries sheet. Macro should be self-sufficient including first clearing the criteria range. Create macro button Query worksheet.

Queries worksheet:

Database worksheet:

Please provide necessary steps/formula(s) so I can solve the question in excel. Thank you!

A B D E F H I K L M N 0 P 0 RS T U V w Create Macro buttons Tor Question I and Question 2 Below in Gray Area. Label the macro button as Questoni and Questionz. 1 2 Macro Questions Criteria 4 Q1 5 6 7 8 Put your answer in this cell Years in 9 Emp ID Last Name First Name Department Division Salary Hire Date Birth Date Age Service New Salary1 New Salary 2 Birth Month 10 11 12 13 14 15 16 17 18 19 20 Q2 Put your answer in this ocll Years in Service Salary Hire Date Birth Date Age New Salary1 New Salary 2 Birth Month 21 Emp ID Last Name First Name Department Division 22 23 24 25 26 27 28 Create Macro button for each question in "Database" worksheet. 29 A B D E F H K M Emp ID 1011 Birth Date 11/21/64 12294 9/21/95 8/9/87 Years in Service 21 15 19 Age 56 36 55 33 53 Division Copiar Printer Printer Copiar Coplor Printer Printer Printer Copiar 1012 1041 1054 1055 1075 1152 1153 1167 12 22 First Name Hazel Liza Robert Howard Madine Sheryl Mark Allan Sam Toni Joramy Linda 14 21 57 50 50 12 20 Fax Copier 1169 1199 1290 1299 1300 1301 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 Last Name Gorton Preston Tercan Smith Albert Kane Henders Plant Barwick Asonte Dorfberg Cooper Simpson Richards Sindole Smith Cane Vuando Solznick Cash Szcznyck Kanako Lampstone Ball Quan 16 15 35 55 Fax Copiar Printer Fax Department Accounting Engineering Rand D Art Marketing Art Accounting Accounting Marketing Engineering Engineering Admin Engineering Accounting Marketing Engineering Marketing Engineering Accounting Engineering Engineering Rand D Marketing Accounting Engineering Engineering Admin Rand D Engineering Admin Salary $27 597 85 $43,394.15 $28.043.00 $25.170.00 $26.040.56 $23.239.44 $26.646.20 $28.043.00 $31.913.80 $63,035.89 $58,002.05 $26.113.96 $34,85420 $30,451.60 $27,081.04 $32.410.45 $43.496.95 $55.410.95 $31,539.24 $49.872.15 $59.382.20 $28,043.68 $64,699.00 $28,549.50 $75,599.00 $45, 146.68 $25, 146.68 $41,053.49 $29.382.20 $27,081.04 Hire Date 2300 1/2606 4/16/02 4/16/09 48/99 8/7106 1/21/00 1/13/09 4/18/01 4/10/99 10/13799 1/3/05 12/21/05 12/13193 86/08 101496 9/26/02 2/22/09 2/14/99 5/11/99 4/16/95 4/8/98 91995 31604 2126799 1/29/07 1/20/91 5/11/96 11/26/05 8/18/09 8/20167 8/29/79 10/23/71 11/3/63 9/29/70 710/70 7/12/70 10/1/06 9/16/95 912465 6/26461 11/295 11/13/54 5664 9/23/68 5/21/64 10/7165 10/18/65 9/23/58 6/26163 7/7/63 59 12 New Salary1 New Salary 2 Birth Month $30,281.74 $30,909.59 Nov $43,394.15 $47,082.65 Dec $29,796.41 $31,408.92 Sep $25,176.06 $28,197.19 Aug $28,573.00 $29,165.43 Aug $23,239.44 $26,028.17 Aug $29,237.54 $29,843.74 Oct $28,043.68 $31,408.92 Nov $35,017.50 $35,743.55 Sep $69,166.12 $70,600.19 Jul $63,642.75 $ 64,962.30 Jul $27,745.98 $29,247.52 Oct $34,854.20 $37,816.81 Sep $33,413.11 $34,105.88 Sep $27,081.04 $29,382.93 Jun $35,562.81 $36,300.15 Nov $46,204.88 $48,705.38 Nov $55,410.85 $60,120.77 May $34,606.43 $35,323.95 Sep $54,722.22 $55,856.81 May $65,135.17 $66,485.66 Oct $30,770.93 $31,408.92 Oct $70,980.01 $72,451.68 Sep $30,333.84 $31,975.44 Jun $82,940.69 $84,660.35 Jul $45, 146.68 $48,984.15 Sep $27,592.19 $28,164.28 Jan $45,045.93 $45,979.90 Jan $29,362.20 $31,857.99 Sep $27,081.04 $30,330.76 Mar 1310 Fax 55 34 18 Sandra Phillip Randy Ellen Nate Tuoma Anna Mary Tadeuz Midori Pote Tom Karan Tommia lain Alexandra Karen 1311 1329 1330 12 52 21 55 1331 1333 1334 1426 25 23 55 62 35 Printer Printer Copiar Printer Copiar Fax Fax Printer Printer Printer Printer Copior Printer Copiar 17 1516 1517 1529 57 57 32 49 1530 30 1531 1536 Kallarman Stewart Lempert Davison Bates 9/10/71 1/1567 1/1967 9/23187 3122190 54 33 31 14 1557 Lisa 11 B D E F G H - J L M 25 1558 1657 1674 1675 1675 1676 1677 1723 1724 Marketing Accounting Accounting Accounting Marketing Admin Rand D Engineering Marketing 10/1605 126/02 312506 3/17/96 10/26/98 10/1801 11/6/07 8/6/98 19 13 7129197 12/2407 12/16/03 23 13 1792 9/26,82 10/10183 1/17190 1/2964 9/1/99 9/1282 9/16/99 9123165 5/21/65 10/3168 10/14/76 10/18/96 9/29/99 9/1/99 44 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 17 34 Sargent Walls Boughton Molandez Miller Walls Levine Alstain Chu Barton Abla Goldberg A-Sabah Lin Mueller Fontaine Mueller Corwick Aruda Martinez Franklin Petry Maguire Silverberg Evelyn Rose Frank Jaime Janet Jason Eric Isolde Steven Eileen Aaron Malcolm Daoud Michael Ursula Joan Kris Rob Folica Sara Larry Robin Mollie Jay Copior Printer Fax Fax Copiar Copiar Fax Fax Printer Copier Fax Fax Faxc Fax Copier Copier Fax Fax Copior Copier Copier Printer Copiar Fax 899 388 49 3 &&&99 98 $41,987.40 $32,626.90 $27.597.85 $29.045.24 $33,301.44 $23.212.32 $37.995.52 $89.382.20 $28.043.68 $28,959.25 $24,179.50 $57.489.75 $51,303.60 $35,490.40 $36,101.44 $28,043.68 $27.091.04 $23.239.44 $23 212.32 $35.999 20 $21.997.95 $33,035.88 $30.013.62 $51.878.84 Admin Marketing Engineering Engineering Accounting Aco Admin 2/18/08 34/92 13 29 E BE=e = = 1793 1794 1814 1816 1931 1990 1961 1996 1967 1968 1975 1976 1977 1978 $44,611.61 $47,025.89 Sep $34,665.98 $36,542.02 Oct $27,597.85 $30,909.59 Jan $31,869.89 $32,530.67 Jan $36,540.01 $37,297.61 Sep $25,469.72 $25,997.80 Sep $37,895.52 $41,116.64 Sep $76,107.67 $77,685.66 Sep $30,770.93 $31,408.92 May $28,859.25 $32,322.36 Oct $25,690.72 $27,081.04 Oct $57,488.75 $62,375.29 Oct $56,292.88 $57,460.03 Sep $37,697.93 $39,738.05 Sep $36, 101.44 $40,433.61 May $30,770.93 $31,408.92 Mar $27,081.04 $30,330.76 Apr $25,499.48 $26,028.17 May $25,469.72 $25,997.80 May $39,489.15 $40,307.90 May $24,016.55 $24,514.50 Sep $36,248.62 $37,000.19 Oct $32,932.44 $33,615.25 Sep $51,878.84 $56,288.54 Oct 718/02 5/28186 34 6/20/09 11/13/92 11,506 18 11 29 312265 412165 5499 14 Admin Marketing Accounting Engineering 11/17/91 11/9/91 1/1/93 5/7/97 4/29/01 6/1300 1/508 5/15/09 5/1999 9/28/70 10/9/79 41 29 23 20 20 13 39 9/21/81 10/18191 Engineering 29