Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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 AE2 contains the cut-off date against which to compare the hire date to determine the length of service.What is the correct formula to determine the length of employment in complete months?O-DATEDIF($AE$2, C2, "diff")O-DATEDIF(C2, $AE$2,"m")ODATEDIF(C2, $AE$2, "date")O=DATEDIF($AE$2, C2,"mth")

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

More Books

Students also viewed these Databases questions

Question

How will VSAT technology better serve employees?

Answered: 1 week ago

Question

fscanf retums a special value EOF that stands for...

Answered: 1 week ago