Answered step by step
Verified Expert Solution
Link Copied!

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.

image text in transcribed

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

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Fundamental Accounting Principles

Authors: John J Wild, Ken Shaw

24th edition

1259916960, 978-1259916960

Students also viewed these Accounting questions