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.