View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
TryingTime
 
Posts: n/a
Default Calculate number of years and months employed using hire date and.

In Excel 2003, I want to calculate the number of years and months employed
using a hire date and the current date. i.e.
06/28/2006 €“ 06/25/2005 = 11 months
06/28/2006 €“ 06/25/2004 = 1 year 11 months
06/28/2006 €“ 08/01/2000 = 5 years 10 months
06/28/2006 €“ 04/01/2000 = 6 years 2 months

Somebody must have done this before, yes?