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

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?
 
P

Peo Sjoblom

=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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Searching for records with multiple criteria 7
Complete Tax Years 1
Allocate an income payment over a date range (tax years) 7
Calculating the difference between two dates if two criteria are m 3
Calculate End Date Using Start Date and No. of Days excluding specific days. 0
Calculate Months to Determine Length of Service 7
Calculating time between mulitple dates 4
Sum value between two dates and copy to new cell 6

Top