Calculating vacation accrual

[Strike!]

You got to be kidding me!

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

Get real.

 

[Teri]

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!

 

[Teri]

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).

 

[JulieD]

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

 

[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

 

[JulieD]

Hi Terri

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

Cheers
JulieD

 

[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

 

[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

 

[Teri]

Hi Julie,

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

Teri