Welcome to the forum.
Please upload a mock-up of a workbook showing how the above is anticipated to work.
I'm confused by the 61 days. Is that every 61 days or just once per year or just once for their career. I take it that all the days earned are vacation days. Are there other days to be accounted for?
Are the days awarded as a lump amount at the beginning of the year after the anniversary date?
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
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.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
ehdz0222 
Register To Reply
Bookmarks