Excel Formula Help

826 Views 6 Replies 2 Participants Last post by  The Villan
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?
Status
Not open for further replies.
1 - 7 of 7 Posts
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?
PM sent
When you say 3 weeks, do you mean 15 working days or 21 days?
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
I am not sure I understand the question. Did you mean \$20,000/yr would get 1 day at a 6% calculation?
Yes. you need to say what constitutes each days holiday.
Example Vlookup sent to you as a spreadsheet. Just simple at this moment until I know all your requirements.
1 - 7 of 7 Posts
Status
Not open for further replies.