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. For one service recognition program, you need to calculate the length of service in complete months. What is the correct formula?
A)=DATEDIF(C2, $AE$2, "m")
B)=DATEDIF($AE$2, C2, "month")
C)=DATEDIF($AE$2, C2, "mth")
D)=DATEDIF(C2, $AE$2, "mon")

Question

Quizplus · Accepted Answer

The correct formula for calculating the length of service in complete months is to use the DATEDIF function with the "m" parameter. Option A uses the correct syntax of DATEDIF(start_date, end_date, "m"), with the start_date being the employee's hire date (C2), the end_date being the cut-off date ($AE$2), and the "m" parameter indicating that the function should return the number of complete months between the two dates. Options B, C, and D either use incorrect syntax or incorrect parameters for the DATEDIF function.

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