Answered step by step
Verified Expert Solution
Question
1 Approved Answer
insert a formula into cell E6 that subtracts the hire date in cell D6 from the date in cell D1, and divides that result by
insert a formula into cell E6 that subtracts the hire date in cell D6 from the date in cell D1, and divides that result by 365. Set up the formulas so it can be copied by other cells in Column E while continuing to reference the date in Cell D1 and divide by the number 365. Make sure there are no blank spaces within the formula. Remove all decimal places from the result.
please make sure to explain everything in a very detail and organized way that is easy to understand.
1 Junior High 7/18/2018 3 Employee Information Sheet 5 Employee ID 6 G-1256 7 G-1265 8 G-1287 9 G-1440 10 G-1455 11 G-1522 12 G-1703 13 G-2210 14 G-2344 15 G-3001 16 G-3211 17 G-3254 18 G-4429 19 lon Employee Name Noah Jackson Bruce Thompson Chet Hynne Yarl Hess Myra Chiz Andy Heave Kelly Browder Linda Black Donna Fox Billy Kreight Sylvia Sunne Stan Yerden Ingrid Simcoe Position Theatre Science Psychology Health Science Math Business English Math Entrepreneurship Music Financial Aid Adminstrative English Date of Hire How many years? Tue, Apr. 30, 1996 Tue, Dec. 08, 2009 Sat, Feb. 06, 1982 Sat, May. 09, 2015 Fri, Jun. 02, 1989 Tue, Oct. 29, 2013 Sat, Mar. 19, 2016 Sat, Dec. 15, 1984 Fri, May 15, 2015 Sun, Mar. 19, 1989 Thu, Nov. 09, 1995 Wed, Feb. 09, 2011 Tue, Oct. 10, 2000Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started