I’m new at Monday !
I am looking for a conditional formula to calculate vacations rights related to employee senority (years)
- Employees have 30 vacations days after 10 years maximum
- Employees have 29 vacations days from 8 to 10 years
- Employees have 28 vacations days from 6 to 8 years
- Employees have 27 vacations days from 4 to 6 years
- Employees have 26 vacations days from 2 to 4 years
- Employees have 25 vacations days from 0 to 2 years
I have the ‘‘senority years’’ in the company as my base data so I need the formula to calculate the vacation days they have. IF & AND formula
Maria 1.2 years in the company
José 8.5 years in the company etc…
Thank you so much!!