Question: 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, 2000
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
