Formula IF & AND help - VACATION RIGHTS

Platform discussions Special workflows & use cases
1

Hi guys :stuck_out_tongue_winking_eye:

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!!

2

@Izobelle,

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
3

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

Best

Isabelle

4

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