I need to set up a spread sheet for tracking vacation with accurals. I am
not very good at creating formulas. Can anyone help? It goes by the
employee's hire date.
After 1 yr - 1 week vacation
2 - 10 yrs - 2 weeks
10 + years - 3 weeks

We get paid weekly so it needs to accural for each pay period not monthy.