PM sentI 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?
Excel Formula Help
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?
Are you able to assist me in coming up with the proper formula?
- Status
- Not open for further replies.
1 - 7 of 7 Posts
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
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.
Tech Support Guy
A forum community dedicated to tech experts and enthusiasts. Come join the discussion about articles, computer security, Mac, Microsoft, Linux, hardware, networking, gaming, reviews, accessories, and more!
Full Forum Listing
Explore Our Forums
