Calculating vacation accrual

  • Thread starter Thread starter Strike!
  • Start date Start date
S

Strike!

You got to be kidding me!

7 measly days of vacation after almost 13 yrs of service?

Get real.
 
I don't think "Strike's" answer was what I was looking for. If anybody else
wants to know, Mr. A already gets 15 days vacation PLUS the accrued for the
year. I hope this will encourage others to help me with my problem. Thank
you!
 
Thanks for your response!

Cell E45 = Hire Day
Cell D8 = NOW()

The accrued vacation increments each month beginning with February 1 through
November 1 (up to 10 days per year).
 
Hi,

Not clear to me but you may try :

=MIN(10,DATEDIF(E45,D8,"ym")+(E45<=10))

If it's not right. Please give 4 or 5 critical examples with expected results so
that we can better figure out your problem.

Regards,

Daniel M.
 
Daniel,

This is SO CLOSE!! I'll give some examples here:

Mr. A has 3 years of service. After one year, our company gives 10 days of
vacation. His hire day is 9/22. As of 9/1/04 of this year, he will have
accrued 8 days of vacation.

Mr. B has 13 years of service. After one year, our company gives 15 days of
vacation. His hire day is also 9/22. As of 9/1/04 of this year, he will
have accrued 10 days of vacation.

Ms. C has 3 years of service. After one year, our company gives 10 days of
vacation. Her hire day is 9/08. As of 9/1/04 of this year, she will have
accrued 9 days of vacation.

Ms. D has 13 years of service. After one year, our company gives 15 days of
vacation. Her hire day is also 9/08. As of 9/1/04 of this year, she will
have accrued 11 days of vacation.

As you can see, if someone was hired on or before the 10th of January, they
start accruing one day for each month up to 10 (with less than 7 years of
service). If they were hired after the 10th, they will start accruing in
February.

If someone was hired on or before the 10th of January, they start accruing
1-1/2 days for each month up to 12 (with 7+ years of service). If they were
hired after the 10th, they will start accruing in February.

I'm sorry this is so complex -- that's why I need this forum's help :)
 
Hi Teri

haven't seen your posts previously ... but was wondering after how many
years of service do you move from 10 days to 15 days of vacation? and are
there any other increments like this?

are you only interested in how many days they have accrued up to the current
date this year or are you looking also at them taking their leave or
carrying the leave over?

Cheers
JulieD
 
Hi Teri

few things don't make sense to me:

if the only difference between these two is the year that they were hired in
then as far as i understand your next paragraph Mr B should have 12 not 10
days of vacation. - being 1.5 days per month rather than 1 day per month.
Additionally in your other post you said that someone with 7+ years of
service gets 15 days of vacation per year - here you state 12 ... what am i
missing?

Could you please clarify.

Cheers
JulieD
 
Hi Terri

1.25 makes more sense .. thanks will get back to you hopefully soon.

Cheers
JulieD
 
Hi Teri

I've split it up into different columns ... i'm guessing it could be
combined into less but let's make sure the formula works in all situations
first:

place the person's name in column A
place the day that the person started in column B
place the month that the person started in column C
place the year that the person started in column D
place the evaluation day in column E
place the evaluation month in column F
place the evaluation year in column G

so for Mr A
A Mr A
B 22
C 9
D 2001
E 1
F 9
G 2004

and in column H type the following formula
=ROUND(IF(G2-D2>7,IF(B2<=10,F2,F2-1)*1.25,IF(B2<=10,F2,F2-1)),0)

test for all your people.

Please let me know how you go.

Cheers
JulieD
 
Hi Teri

glad to assist.

did you want me to try and combine the formula a bit neater or are you happy
with it as is?

Cheers
JulieD
 
Hi Julie,

Thanks for the offer, but the formula works just fine! I really appreciate
your assistance!

Teri
 
Back
Top