The way I would approach it would be to incrementalize (is that a word?)
everything first: figure the accruals by pay period by employee in a big
table, then gross up results by employee by year. It occurred to me that
you should separate check date from anniversary date.

Hope this makes sense... let me know if not.

Mariela wrote:
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.