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.

If the hire date is in A1 then:
=IF((TODAY()-A1)/365.25=10,3,IF(((TODAY()-A1)/365.25=2),2,IF((TODAY()-A1)/365.25=1,1,0)))

--
Gary''s Student


"Rae" wrote:

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.