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")
Correct Answer:
Verified
Q71: The _ function adds the values in
Q72: You have been using a variety of
Q73: Evaluate the formula =AND(G2="FT",M2>=1) based upon the
Q74: To change the background fill color of
Q75: Your boss in the human resources department
Q77: You can edit existing conditional formatting rules
Q78: You can edit existing conditional formatting _
Q79: The _ function calculates the number of
Q80: You have been using a variety of
Q81: The _ function is used to change
Unlock this Answer For Free Now!
View this answer and more for free by performing one of the following actions
Scan the QR code to install the App and get 2 free unlocks
Unlock quizzes for free by uploading documents