LinkBack URL
About LinkBacks
I'm confused. Is accrual based on time until May 1st of the current Fiscal Year, like you said in your first post; or is it based on time until today?
I'm confused. Is accrual based on time until May 1st of the current Fiscal Year, like you said in your first post; or is it based on time until today?
Click the [* Add Reputation] Button to thank people for help!
Post Attachment: Click [Go Advanced] under the reply box; then click [Manage Attachments] to launch the attachments dialogue.
Mark Thread Solved: Go to the top of the first post; Select [Thread Tools] dropdown; Pick the [Mark thread as Solved] option.
Sorry for the long delay in responding. We had a death in our workplace family.
The short answer is both.
Full years of service from May 1st to April 30th [10 days after 1 year to 4 years, 15 days after 4 years to 10 years, 20 days after 10 years to 18 years, and 25 days after 18 years]
...and employees working here under 1 year of service, get 1 day for every full month of continuous service [date of hire to TODAY()] up to 10 days.
Does that make sense?
This is what I have so far. As you can see in the attached workbook employees 59 to 71 don't calculate right.
Examples:
Employee 59 started on July 25, 2016, and should have accumulated 10 days.
Employee 68 started on October 16, 2017, and should have accumulated 3 days (as of today).
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks