# Excel Formula Help

Discussion in 'Business Applications' started by Penelope-Jenn, Jul 8, 2014.

Not open for further replies.

Joined:
Mar 9, 2008
Messages:
31
I am looking to create a spreadsheet that calculates vacation accrual and takes into account Flex Days, etc. Vacation accrual is accumulated at 6% of someones gross pay so at the end of 52 weeks, it would add up to their alotted vacation. I.E. I get 3 weeks a year. Not everyone gets Flex Days so I would only calculate this for those that get them.

Are you able to assist me in coming up with the proper formula?

Joined:
Feb 20, 2006
Messages:
2,255
PM sent

3. ### The Villan

Joined:
Feb 20, 2006
Messages:
2,255
When you say 3 weeks, do you mean 15 working days or 21 days?

4. ### The Villan

Joined:
Feb 20, 2006
Messages:
2,255
6% of gross pay, would be different for each person. So how do you define what % means in terms of days for each person? Do you have a scale? For example

20,000 =1 day
25,000 = 2 days
30, 000 = 3 days
etc etc

Joined:
Mar 9, 2008
Messages:
31
I am not sure I understand the question. Did you mean \$20,000/yr would get 1 day at a 6% calculation?

6. ### The Villan

Joined:
Feb 20, 2006
Messages:
2,255
Yes. you need to say what constitutes each days holiday.

7. ### The Villan

Joined:
Feb 20, 2006
Messages:
2,255
Example Vlookup sent to you as a spreadsheet. Just simple at this moment until I know all your requirements.

As Seen On