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?

Calculate number of years and months employed using hire date and.
 

=DATEDIF(start_date,end_date,"y")

=DATEDIF(start_date,end_date,"ym")

=DATEDIF(start_date,end_date,"m")

--

Regards,

Peo Sjoblom

Excel 95 - Excel 2007
Northwest Excel Solutions
www.nwexcelsolutions.com
"It is a good thing to follow the first law of holes;
if you are in one stop digging." Lord Healey


"TryingTime" wrote in message
...
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?