If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|