# Formula IF & AND help - VACATION RIGHTS

Hi guys

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

Ex:
Maria 1.2 years in the company
José 8.5 years in the company etc…

Thank you so much!!

Here is one way:

``````25 + IF({Years}>=2,1,0) + IF({Years}>=4,1,0) + IF({Years}>=6,1,0) + IF({Years}>=8,1,0) + IF({Years}>=10,1,0)
``````

Or, depending on how you want it to work:

``````25 + IF({Years}>2,1,0) + IF({Years}>4,1,0) + IF({Years}>6,1,0) + IF({Years}>8,1,0) + IF({Years}>10,1,0)
``````

Jim

1 Like

Thank you s much it’s working just fine!!

Best

Isabelle

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.