Vacation Accruals


M

Mariela

I have searched high and low and I cannot find an anwer to my dilemma and I
have tried a multitude of examples from various sources. My company accrues
PTO on bi-weekly basis as follows:

1 to 5 Years 4.62 Hours Biweekly
6 to 15 years 6.15 Hours Biweekly
15+ years 7.70

On one of the anniversary years, the employee changes the accrual of the
vacation on the paycheck of his anniversary. Example Employee Hire Date is
4/5/04, the employee will accrue 4.62 hours per paycheck until the paycheck
of 4/10/09 where he will start accruing at 6.15 for the remainder of the
paychecks for that year.

My Columns are
A1 Name
B1 Date of Hire
C1 Anniversary Date

I have tried HLookup to an array, I have tried IF formula's but nothing
gives me the right results. Is anyone out there able to help?????
 
Ad

Advertisements

M

Mariela

Thank you smartin for your quick response. This gives me the accrual amount
that should be calculated on their anniversary date (column C), which is
good, I think this gets me one step closer to what I need.

However, I need a formula that will calculate the accrual for the year
taking into account the change of accrual as of the anniversary date.
 
M

Mariela

Thanks smartin, with your suggestion yesterday and breaking it down to a few
coulmns adn VLookup, I was able to get the results I needed. Thanks for your
help!
 
Ad

Advertisements

G

Gail Moul

Hi Mariela
I have searched high and low and I cannot find an anwer to my dilemma and I
have tried a multitude of examples from various sources. My company accrues
PTO on bi-weekly basis as follows:

1 to 5 Years 4.62 Hours Biweekly
6 to 15 years 6.15 Hours Biweekly
15+ years 7.70

On one of the anniversary years, the employee changes the accrual of the
vacation on the paycheck of his anniversary. Example Employee Hire Date is
4/5/04, the employee will accrue 4.62 hours per paycheck until the paycheck
of 4/10/09 where he will start accruing at 6.15 for the remainder of the
paychecks for that year.

My Columns are
A1 Name
B1 Date of Hire
C1 Anniversary Date

I have tried HLookup to an array, I have tried IF formula's but nothing
gives me the right results. Is anyone out there able to help?????
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top