HELP-Formula needed to Calculate Accrued vacation days

[mw11083]

I am in need of a formula to calculate the accrued vacation days available for an employee based on the following criteria:

Hire date is 1/1/2012
using as of 3/30/2014 instead of today,how many days would an employee accrue using the below policy guidelines:

1yr=0 eligibility
1yr>2yrs =5 days
>2yrs or more= 10 days

Thank you

[alansidman]

Try this:

=IF((TODAY()-A2)<=365,0,IF(AND((TODAY()-A2)>365,(TODAY()-A2)<730),5,10))

Assuming Hire date is in A2

[Kevin UK]

Hi

Or may be the following formula and also assuming the date is in A2.

Please Login or Register  to view this content.

[mw11083]

Thank you, however, I am looking for the decimals. According to the above policy the employee would not receive all 5 days until 2yr anniversary,however after the first year they start to accrue. Therefore if an employee worked 1 1/2 years, hire date still 1/1/12. how many vacation days have they accrued as of today. the answer should be approximately 2.5 days correct?

Try this:

=IF((TODAY()-A2)<=365,0,IF(AND((TODAY()-A2)>365,(TODAY()-A2)<730),5,10))

Assuming Hire date is in A2

[mw11083]

Hi

Or may be the following formula and also assuming the date is in A2.

Please Login or Register  to view this content.

Thank you, however, I am looking for the decimals. According to the above policy the employee would not receive all 5 days until 2yr anniversary,however after the first year they start to accrue. Therefore if an employee worked 1 1/2 years, hire date still 1/1/12. how many vacation days have they accrued as of today. the answer should be approximately 2.5 days correct?

[alansidman]

What are the increments of accrual. Do they earn 5/12 of a day for each month worked? Is it based upon months or days? Give us more information on your algorithm.