The formula is the same, except you replace the Y with an M for months
divide this by 12, therfore the formula looks like the following:-

=DATEDIF(C1,D1,"M")/12

This will then give you as per your example:-

0000001 Employer B 1998-10-01 2000-07-01 1.75
0000001 Employer C 1998-05-01 1998-08-01 0.25
0000002 Employer D 2000-02-01 2001-03-15 1.08
0000002 Employer E 1999-06-01 2000-01-01 0.58
0000003 Employer F 1998-06-01 1998-08-31 0.17
0000003 Employer G 1996-12-01 1998-05-31 1.42
0000004 Employer H 1998-03-30 1999-12-29 1.67

Then you can either do a pivot table to get the totals for employee
0000001, 0000002 etc or you could have a table with the following
formulas

A B
1 0000001 =sumif(employee ids - table above,A1,datedif
calculation)
2 0000002 =sumif(employee ids - table above,A1,datedif
calculation)
3 0000003 =sumif(employee ids - table above,A1,datedif
calculation)
4 0000004 =sumif(employee ids - table above,A1,datedif
calculation)

I have enclosed a smaple zipped up spreadsheet for you to have a look
at


+-------------------------------------------------------------------+
|Filename: Example1.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4435 |
+-------------------------------------------------------------------+

--
Gary Brown
------------------------------------------------------------------------
Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084
View this thread: http://www.excelforum.com/showthread...hreadid=520668