How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask linda_us Your Own Question

linda_us, Master's Degree
Category: Business and Finance Homework
Satisfied Customers: 852
Experience:  A tutor for Business, Finance, Accounts and other related topics.
Type Your Business and Finance Homework Question Here...
linda_us is online now
A new question is answered every 9 seconds

From the attached list, I need to identify the closest re

Customer Question

From the attached list, I need to identify the closest hire date for each employee before 5/1/2016. For example Employee 11351 has the following dates 3/6/2012, 8/1/2013 and 8/19/2013, the report should return a value of 8/19/2013 but employee 20697 has the following dates 1/22/2014, 8/21/2014 and6/3/2016, the report should return a value of 8/21/2014.
Submitted: 3 months ago.
Category: Business and Finance Homework
Customer: replied 3 months ago.
I need to know what excel formula is used to arrive at the answer
Expert:  F. Naz replied 3 months ago.

There is no attached file here, please attached the file, thanks.