If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
Thread Tools | |
Display Modes | |
|
|