Calculating the Length of Service between Hire and Termination dat

S

Shams

Let's say somebody was hired on October 2, 2006 and left on August 14, 2009.
I know that the YEAR function will return a value of 3.0. Is there a way I
could calculate the Year and month i.e. in this case the length of service is
2 years and 10 months (ignoring the exact day of hire and termination)

Or is there another acceptable way of showig Length of Service? Thanks.
 
J

JLatham

With hire date in A1 and termination date in B1
=DATEDIF(A1,B1,"Y")&" Y, "&DATEDIF(A1,B1,"ym")&" M, "&DATEDIF(A1,B1,"md")&" D"
will give you the answer down to days! You can leave off the days part with:
=DATEDIF(A1,B1,"Y")&" Y, "&DATEDIF(A1,B1,"ym")&" M"

Courtesy of Chip Pearson: http://www.cpearson.com/excel/datetimews.htm
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate the number of days from a specific date 5
Vacation Accrual - Challenge 2
Calculate number of years and months employed using hire date and. 1
Calculating Average Length of Service 2
Break on Calendar Year 4
How can I calculate Vacation Time earned based on length of emplo. 2
Count the Number of Weekdays by Month 3
add 2 months and a variable number of days to a date 3

Top