Computers and Technology, 12.03.2020 04:20 atran4820

Your boss in the human resources department asks you to write a function that calculates the length of time that employees have been with the firm, using the DATEDIF function. Assume that C2 contains the hire date for a given employee and that cell $AE$2 contains the cut-off date against which to compare the hire date to determine length of service. For a separate service recognition program, you need to calculate the length of service in complete years. What is the correct formula?
A) =DATEDIF(C2, $AE$2, "yr")
B) =DATEDIF($AE$2, C2, "year")
C) =DATEDIF($AE$2, C2, "yr")
D) =DATEDIF(C2, $AE$2, "y")

Answers: 3

Show answers

Other questions on the subject: Computers and Technology

Computers and Technology, 22.06.2019 13:00, cookie1701

Why the bear has a slunky tail determine the meaning of the word slunk in the story

Answers: 1

continue

Computers and Technology, 22.06.2019 15:10, reycaden

David is in week 3 of his current ashford course and has a paper due by monday night at midnight. he has finished everything but the concluding paragraph. as he boots up his computer to work on it, he sees a flash across the screen and then the screen goes black. he begins to panic as he tries desperately to turn the laptop back on. david should have saved his work on what kind of portable device?

Answers: 2

continue

Computers and Technology, 23.06.2019 13:00, alexacarillo

In excel - calculate the actual increase/decrease from first quarter to the second quarter then subtract subtract first quarter value from second quarter total then divide result by first quarter value

Answers: 1

continue

Computers and Technology, 23.06.2019 16:30, rileysndr1782

Monica and her team have implemented is successfully in an organization. what factor leads to successful is implementation? good between different departments in an organization leads to successful is implementation.

Answers: 1

continue

You know the right answer?

Your boss in the human resources department asks you to write a function that calculates the length...