Accrued Vacation

[Kim Campbell via OfficeKB.com]

Hi,

I need help creating a formula to calculate accrued vacation time. Employees earn either 1, 1.5, or 2 days of vacation time on their anniversatry date each month. How can I create a forumla that will automatically compute everyone's vacation time?

Thanks in advance for your help!

 

[JulieD]

Hi

what is the basis of whether they get 1, 1.5 or 2 days?

Cheers
JulieD

 

[Myrna Larson]

I think the easiest way would be to create a table to use with VLOOKUP that
has the required length of service (in months?) in the 1st column, and the
number of weeks varaction in the 2nd, i.e. something like

0 0
6 1
12 1.5
36 2.0

assuming they get no vacation until they have completed 6 months, then 1
month, increasing to 1.5 after 12 months, and to 2 after 36 months.

Then if you have the date of hire in, say, column B, and the above table is in
cells K1:L4, the formula for vacation is

=VLOOKUP(B2,$K$1:$L$4,2)

Hi,

I need help creating a formula to calculate accrued vacation time. Employees

earn either 1, 1.5, or 2 days of vacation time on their anniversatry date each
month. How can I create a forumla that will automatically compute everyone's
vacation time?

 

[Myrna Larson]

Oops. That formula should be

=VLOOKUP(DATEDIF(B2,TODAY(),"m"),$K$1:$L$4,2)

 

[JulieD]

Hi Kim

did Myrna's answer give you what you're looking for?

Cheers
JulieD

 

[Kim Campbell via OfficeKB.com]

It depends on how long they've been with the university.