![subject](/tpl/images/cats/informatica.png)
Computers and Technology, 12.03.2020 04:20 atran4820
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](/tpl/images/cats/User.png)
Answers: 3
![](/tpl/images/ask_question.png)
![](/tpl/images/ask_question_mob.png)
Other questions on the subject: Computers and Technology
![image](/tpl/images/cats/informatica.png)
Computers and Technology, 22.06.2019 08:30, marialuizavalen
Today is the anniversary of me being on yet, i don't need it anymore! here's a picture of my dog wearing a bowtie! my question is, how do i delete my account?
Answers: 1
![image](/tpl/images/cats/informatica.png)
Computers and Technology, 23.06.2019 13:00, dimondqueen511
Which one of the following voltages should never be measured directly with a vom? a. 1200 v b. 500 v c. 800 v d. 100v
Answers: 2
![image](/tpl/images/cats/informatica.png)
![image](/tpl/images/cats/informatica.png)
Computers and Technology, 23.06.2019 17:30, cxttiemsp021
Per the municipal solid waste report, what are the most common sources of waste (trash
Answers: 3
You know the right answer?
Your boss in the human resources department asks you to write a function that calculates the length...
Questions in other subjects:
![Konu](/tpl/images/cats/mat.png)
Mathematics, 19.02.2020 03:39
![Konu](/tpl/images/cats/informatica.png)
![Konu](/tpl/images/cats/mat.png)
Mathematics, 19.02.2020 03:39
![Konu](/tpl/images/cats/mat.png)
Mathematics, 19.02.2020 03:39
![Konu](/tpl/images/cats/obshestvoznanie.png)
![Konu](/tpl/images/cats/en.png)
![Konu](/tpl/images/cats/informatica.png)
![Konu](/tpl/images/cats/obshestvoznanie.png)
![Konu](/tpl/images/cats/mat.png)
Mathematics, 19.02.2020 03:40
![Konu](/tpl/images/cats/biologiya.png)
Biology, 19.02.2020 03:40