Vacation Accruals

[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?????

 

[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.

 

[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!

 

[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?????