CALCULATE FUTURE DATES

For example, the termination date is in A1, the number of severance days is
in B1. Use the following formula in C1:

=A1+B1

You may have to format the result into date format, but that should do the
trick.

--
Michael J. Malinsky


"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.

Lynn,
Here's a few formulas for you. Assumes start date in A1 and end date in B1

Years of service rounded down to nearest year:
=ROUNDDOWN(YEARFRAC(A1,B1,1),0)

Years of service rounded down to nearest half year:
=ROUNDDOWN(YEARFRAC(A1,B1,1)*2,0)/2

Add 2 weeks per year of service. (years of service in C1)
=B1+(C1*14)

You can combine the formulas if you prefer. Post in this thread if you need any help.

Good Luck,
Mark Graesser


----- Lynn wrote: -----

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.

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.