Joe Smith is severed 1/1/08 with 4 years of service with the company. He is
entitled to 4 weeks severance for every year of service. Payments are made 2x
month, and in the above case, would be made over 4 months. His last severance
payment would be April 30. The tool will only be used by myself and
management to track expenses related to severance, not to ensure payments are
made.

"Dave O" wrote:

If I may suggest: propose to the owner of the project or spreadsheet
that you be allowed to make the spreadsheet more intuitive. There are
several good reasons for doing this: if you are responsible for
ensuring payments are made, for instnace, then you need a good tool.
Also, since payroll is a *very* important topic to people, and since
your company is likely contractually obligated to pay those people,
it is a legal exposure, not to mention an embarassment to the company,
if this goes wrong.

So the suggestion is, add enough fields to be able to do the job
properly. If you'll post the severance pay policy this forum can help-
if you'll include the frequency of pay (every two weeks, every week,
every month, etc.) we can create a spreadsheet that will forecast
payments based on severance date and severance policy. Post some
sample data too- but remember for privacy and security to use fake
names and numbers.