Hi Gary -
Thanks so much for responding. I'm not familiar with the DATEDIF
formula. I could be missing something or misreading something, but I'm
not sure that will get me where I need to be.
If my data looks like this:
ID Employer Start Date End Date Years
0000001 Employer B 1998-10-01 2000-07-01 1.8
0000001 Employer C 1998-05-01 1998-08-01 0.3
0000002 Employer D 2000-02-01 2001-03-15 1.1
0000002 Employer E 1999-06-01 2000-01-01 0.6
0000003 Employer F 1998-06-01 1998-08-31 0.2
0000003 Employer G 1996-12-01 1998-05-31 1.5
0000004 Employer H 1998-03-30 1999-12-29 1.8
I want to be able to write a formula that will add 1.8 and 0.3 for
Employee 0000001 and then add 1.1 and 0.6 for Employee 0000002, so that
I can get a total number of years of previous experience for each
employee. I apologize if I'm missing something and appreciate your
patience and help on this!!!!!!
--
johnnygirl51
------------------------------------------------------------------------
johnnygirl51's Profile:
http://www.excelforum.com/member.php...o&userid=21906
View this thread:
http://www.excelforum.com/showthread...hreadid=520668