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.