subject

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")

ansver
Answers: 3

Another question on Computers and Technology

question
Computers and Technology, 23.06.2019 21:30
To move a file or folder in microsoft windows, you can click and hold down the left mouse button while moving your mouse pointer to the location you want the file or folder to be, which is also known as.
Answers: 3
question
Computers and Technology, 24.06.2019 03:30
It is not necessary to develop strategies to separate good information and bad information on the internet. true or false
Answers: 1
question
Computers and Technology, 24.06.2019 17:40
Write a program that begins by reading in a series of positive integers on a single line of input and then computes and prints the product of those integers. integers are accepted and multiplied until the user enters an integer less than 1. this final number is not part of the product. then, the program prints the product. if the first entered number is negative or 0, the program must print “bad input.” and terminate immediately
Answers: 2
question
Computers and Technology, 24.06.2019 21:40
Which of these is not a type of socket? aga (alternating grid array) pga (pin grid array) spga (staggered pin grid array) lga (land grid array)
Answers: 1
You know the right answer?
Your boss in the human resources department asks you to write a function that calculates the length...
Questions
question
History, 30.08.2019 23:00
Questions on the website: 13722367