I'm looking for a vacation/time off template that will show me a schedule for
an individaul employee as well as a rollup of all employees. On the rollup,
would also like to be able to look at a particular day and see who is off
that day. Need to keep track of vacation, personal & sick days. Also, need
help setting up a formula to calculate how many vacation days an employee
will get based on their hire date.

--
Lori

Several Vacation and absence Templates to choose from at the MS Template Gallery

Search found these.............

http://office.microsoft.com/en-us/te...ule+&av=TPL000

For the second part of your question, post the range of vacation days per years
of service then it's just a matter of developing formulas to ascertain
eligibility based on hire date.


Gord Dibben MS Excel MVP

On Wed, 19 Dec 2007 10:11:04 -0800, Lori wrote:

I'm looking for a vacation/time off template that will show me a schedule for
an individaul employee as well as a rollup of all employees. On the rollup,
would also like to be able to look at a particular day and see who is off
that day. Need to keep track of vacation, personal & sick days. Also, need
help setting up a formula to calculate how many vacation days an employee
will get based on their hire date.