Calculating the Length of Service between Hire and Termination dat

  • Thread starter Thread starter Shams
  • Start date Start date
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.
 
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

Calculating time between mulitple dates 4
Vacation days from date of hire 15
Calculate the number of days from a specific date 5
vacation accrual formula 2
Calculating Time by Month 1
DATES 4
Formula to calculate elapsed dates. 2
Calculate Years/Months Between Dates and then Average 3

Back
Top