Length of employment
 

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.

Check out

http://www.cpearson.com/excel/datedif.htm

at Chip Pearson's website for guidance.


"Kim" wrote:

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.

See:

http://www.cpearson.com/excel/datedif.htm

Regards,

Peo Sjoblom

"Kim" wrote:

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.

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


--
Regards Ron de Bruin
http://www.rondebruin.nl



"Kim" wrote in message ...
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.

Thank you! It is perfect! You just saved us SO much time and work!

"Duke Carey" wrote:

Check out

http://www.cpearson.com/excel/datedif.htm

at Chip Pearson's website for guidance.


"Kim" wrote:

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.