View Single Post
  #3   Report Post  
Peo Sjoblom
 
Posts: n/a
Default

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.