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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
=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
 
Back
Top