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 John D Your Own Question
John D
John D, Bachelor of Science - Engineering Consultant
Category: Programming
Satisfied Customers: 9666
Experience:  Vast experience in Excel programming and business solutions
53785
Type Your Programming Question Here...
John D is online now
A new question is answered every 9 seconds

How do I calculate length of service in Excel using Employee

This answer was rated:

How do I calculate length of service in Excel using Employee Start date and today's date. I need to represent it as years and months.

Hi,

 

Ok, let us say you have the start date in A1, type or paste the following formula in B1:

=-DATEDIF(A1,TODAY(),"m")

 

this will give you the number of months between the start data and now.

 

Hope this helps. Let me know if you have any questions.

 

Customer: replied 8 years ago.
John, that just gives me a #VALUE! in B1??

The value in A1 should be a real date in order for the formula to work.

 

Here is a file with the formula;

 

FILE

 

Let me know if you are still having a problem

Customer: replied 8 years ago.
So how then do I display as years e.g. 1.5 instead of negative value?

 

Ok, this one returns the number of years displayed in two decimals.

 

FILE

 

Hope this helps.

 

John D and other Programming Specialists are ready to help you

Related Programming Questions