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
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.



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



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 7 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;




Let me know if you are still having a problem

Customer: replied 7 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.




Hope this helps.


John D and other Programming Specialists are ready to help you