ExcelBanter - vacation with accural

ExcelBanter (https://www.excelbanter.com/)

- Setting up and Configuration of Excel (https://www.excelbanter.com/setting-up-configuration-excel/)

- - vacation with accural (https://www.excelbanter.com/setting-up-configuration-excel/123829-vacation-accural.html)

Rae

vacation with accural

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.

Gary''s Student

vacation with accural

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.

All times are GMT +1. The time now is 02:33 PM.