Hi Lynn!

If you use years and fractions of a year then you can use:

=DATEDIF(A1,B1,"y")+(B1-DATE(YEAR(A1)+DATEDIF(A1,B1,"y"),MONTH(A1),DAY
(A1)))/(DATE(YEAR(A1)+DATEDIF(A1,B1,"y")+1,MONTH(A1),DAY( A1))-DATE(YEA
R(A1)+DATEDIF(A1,B1,"y"),MONTH(A1),DAY(A1)))



(Note: YEARFRAC produces errors where dates are 1 or more years
apart).


DATEDIF is undocumented except in Excel 2000 and is a built in
function. See:

Chip Pearson.
http://www.cpearson.com/excel/datedif.htm

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia

Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
"Lynn" wrote in message
...
I need to calculate benefit and severance end dates from a given
employment termination date and do not know how to do it. For
example:

Termination Date: February 13.
Employees receive 2 weeks severance/benefits per year of service,
the weeks range anywhere from 2 to 50. I do not know how to enter a
formula to calculate the severance/benefit end date.

Thanks for any assistance you can provide.