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

Question

Quizplus · Accepted Answer

The Answer of 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")

Your Boss in the Human Resources Department Asks You to Write