I am learning HR, and I was given the task of coming up with an employee database spreadsheet. I figured out how to do the formula for insurance eligibility, years worked and vacation days, but I am having the hardest time coming up with a formula for paid time off accrual. We accrue it at .42 days/month, making it 5 days per year. It accrues beginning with the hire date, and if you don't use it within the year, you lose it. I tried using the networkdays function and the edate function. I'm just not sure where to begin. Any gurus out there that can help?
Bookmarks