Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Vacation Tracker Formula

0

I am trying to figure a formula for the following:

employees with up to 1 yr get 5 days vacation

the second year they get 5 more

the third year and forward get one more additional day

How do I pose the formula?

thank you!

Answer
Discuss

Answers

0

You should make a table for the vacation time based on years worked and then use a Vlookup function to get the amount.

Here is the sample function:

=VLOOKUP(D2,A2:B21,2)

I included a workbook sample. Adjust the value for the Years column to get the type of calculation that you want. For instance, 1 equals 10 right now because, if they worked there for 1 year, they are then elegible for 10 days of vacation. Adjust the values to suit your business needs.

Discuss


Answer the Question

You must create an account to use the forum. Create an Account or Login