Vacation Tracker Formula


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!




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:


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.


Answer the Question

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