Length of employment

G

Guest

I would like to set up a formula to calculate duration of employment from
Hire Date to Review Date and show results in Years and Months. The date of
hire is in one column and review date in another column. Example: January 1,
2001 to June 30, 2005 with the result being 4 years, 6 months. Thanks for
any help.
 
R

Ron de Bruin

You can use this formula with the dates in D5 and E5
=IF(D5<=E5,DATEDIF(D5,E5,"Y") & " y " & DATEDIF(D5,E5,"ym") & " m","-"&DATEDIF(E5,D5,"y")& " y " &DATEDIF(E5,D5,"ym")& " m")

See this add-in for a easy way to insert formulas in your table
http://www.rondebruin.nl/datarefiner.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

formula help: calculate length of employment 2
formula for lenght of employment based on hire date 1
Eligibility Dates 3
Date formula 3
Date formula rounded up 2
Average of Years employed 4
add 2 months and a variable number of days to a date 3
Calculate Months to Determine Length of Service 7

Top