Vacation Spread sheet

Hi Newdoverman, thanks you for your response. I am attaching the excel sheet I have downloaded for use. It seems to have all I need with the exception of a few things.

Not sure how some of the functions on this sheet work.

- Col A - Some of the dates turn red if DOH is past the year etc.
- Col S - The button to add hours does not work, would be a nice feature but does not work.
- Col Y - I am not sure what the Days count in column Y is for.

As for your questions:

After initial DOH each employee receives at day 61 3 personal days and 3 sick days. If not used throughout the year these 3 days reset regardless on anniversary date, they do not roll over.

Vacation earned:
Yes to above question -
5 Vac days or 40 hours earned after first year anniversary and resets itself each year anniversary date
10 days or 80 hours earned after years 2-4 anniversary date and
15 days or 120 hours earned after year 5 anniversary date

Both vacation and personal/sick days should reset at anniversary dates.