Formula Help

Occasional Visitor

Hello all,


I would urgently need to create a table to showcase how many days our employees have incremented vacation days. Since 2006 they have 5 extra days, but they have never received this up until now in 2023. 

The table should show from 01.01.2006 taken into account that they have 25 days plus each year they have 5 days bonus. That means one of the employees is entitled with 85 days vacation from 2006 to 2023. This need to be a formula in a table. How do I do this?


Thank you,


1 Reply


Attached is an example file, simplified so that you can also follow the path.

Hope I helped you and your employees with this :).



I know I don't know anything (Socrates)