• 100% Satisfaction Guarantee

John D, Bachelor of Science - Engineering Consultant
Category: Programming
Satisfied Customers: 9659
Experience:  Vast experience in Excel programming and business solutions
53785
John D is online now

# How do I calculate length of service in Excel using Employee

### Resolved Question:

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.
Submitted: 5 years ago.
Category: Programming
Expert:  John D replied 5 years ago.

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 5 years ago.
John, that just gives me a #VALUE! in B1??
Expert:  John D replied 5 years ago.

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 5 years ago.
So how then do I display as years e.g. 1.5 instead of negative value?
Expert:  John D replied 5 years ago.

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

FILE

Hope this helps.

John D, Bachelor of Science - Engineering Consultant
Category: Programming
Satisfied Customers: 9659
Experience: Vast experience in Excel programming and business solutions

Ask-a-doc Web sites: If you've got a quick question, you can try to get an answer from sites that say they have various specialists on hand to give quick answers... Justanswer.com.
...leave nothing to chance.
Traffic on JustAnswer rose 14 percent...and had nearly 400,000 page views in 30 days...inquiries related to stress, high blood pressure, drinking and heart pain jumped 33 percent.
Tory Johnson, GMA Workplace Contributor, discusses work-from-home jobs, such as JustAnswer in which verified Experts answer people’s questions.
I will tell you that...the things you have to go through to be an Expert are quite rigorous.

### What Customers are Saying:

• My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
< Last | Next >
• My Expert answered my question promptly and he resolved the issue totally. This is a great service. I am so glad I found it I will definitely use the service again if needed. One Happy Customer New York
• Wonderful service, prompt, efficient, and accurate. Couldn't have asked for more. I cannot thank you enough for your help. Mary C. Freshfield, Liverpool, UK
• This expert is wonderful. They truly know what they are talking about, and they actually care about you. They really helped put my nerves at ease. Thank you so much!!!! Alex Los Angeles, CA
• Thank you for all your help. It is nice to know that this service is here for people like myself, who need answers fast and are not sure who to consult. GP Hesperia, CA
• I couldn't be more satisfied! This is the site I will always come to when I need a second opinion. Justin Kernersville, NC
• Just let me say that this encounter has been entirely professional and most helpful. I liked that I could ask additional questions and get answered in a very short turn around. Esther Woodstock, NY
• Thank you so much for taking your time and knowledge to support my concerns. Not only did you answer my questions, you even took it a step further with replying with more pertinent information I needed to know. Robin Elkton, Maryland

• ### ATLPROG

#### Satisfied Customers:

7463
MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML
< Last | Next >

### ATLPROG

#### Satisfied Customers:

7463
MS in IT.Several years of programming experience in Java C++ C C# Python VB Javascript HTML

### LogicPro

#### Satisfied Customers:

5603
Expert in C, C++, Java, DOT NET, Python, HTML, Javascript, Design.

#### Satisfied Customers:

1158
Good knowledge of OOP principles. 3+ years of programming experience with Java and C++. Sun Certified Java Programmer 5.0.

### lifesaver

#### Satisfied Customers:

950
Several years of intensive programming and application development experience in various platforms.

### ehabtutor

#### Satisfied Customers:

864
Bachelor of computer science, 5+ years experience in software development, software company owner

### Raj

#### Satisfied Customers:

860
BE CS, 4+ Experience in Programming and Database (ERP)

### Eljon

#### Satisfied Customers:

590
11 yrs of programming (PHP, WordPress, XSL, SQL, JavaScript)

## Related Programming Questions

Chat Now With A Programmer
John D
5012 Satisfied Customers
Vast experience in Excel programming and business solutions