Look at the advice offered at this link

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



"ruby" wrote:

I want to calculate number of years, months and days between a hire date and
today's date.