= End date – Start date + 1 Cell A6: Years exact = A5 / 365 Cell A7: Monthly salary = 20000 Cell A8: Daily salary = A7 / 30 Step 3: Calculate Indemnización Indemnización = A8 × 20 × A6

Better: Aguinaldo covers Jan 1 – Dec 31 of year of termination. If termination mid-year:

So: =MIN(10 + (A6-1)*1, 20) * A8