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 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.

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

please make sure to explain everything in a very detail and organized way that is easy to understand.

Answer 1

7/18/2018 5 Employee ID Employee Name Position 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 Step 1 Enter this formula "=($D$1-06)/365" Adding "$" sign to the cell reference for D1 will freeze it, and the link will not change when you drag it to the lower cells Set the format of Cells in Column Eto as shown below, so that it takes off the decimals Format Cells Border Fl Protection Alignment Font Sample Number Category: General Number Currency Accounting Date Time Percentage Fraction Scientific Decimal places: 0 Ouse 1000 Separator) Negative numbers: Text 1234 Special Custom (1234) (1234 Sheeti Sheet2 Sheet3 Ready e Aaa 9