Case-Based Critical Thinking Questions Case 8-2 Your Boss in the Human

Multiple Choice

Case-Based Critical Thinking Questions Case 8-2 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. On a lark, for a year-end trivia contest, your boss wants you to calculate the length of service in complete days. What is the correct formula?

A) =DATEDIF(C2, $AE$2, "today")
B) =DATEDIF($AE$2, C2, "dy")
C) =DATEDIF($AE$2, C2, "day")
D) =DATEDIF(C2, $AE$2, "d")