Length of employment

[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.

 

[Guest]

Check out

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

at Chip Pearson's website for guidance.

 

[Guest]

See:

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

Regards,

Peo Sjoblom

 

[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

 

[Guest]

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