[ \textAguinaldo = \textMonthly salary \times \frac\textDays worked in year365 ]
= 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 calculo de prestaciones honduras excel
Formula: =Aguinaldo = (B1/12) * months worked in calendar year. Daily salary = Monthly salary ÷ 30
For calculation: use Vacation days = 10 + (years-1)*1 (if years>1), max 20. Then multiply by daily salary. In Excel: =MIN(A8 * 20 * A6, A7
Daily salary = Monthly salary ÷ 30. 20 days salary per year worked. Max: 12 months of salary.
In Excel: =MIN(A8 * 20 * A6, A7 * 12) If A6 < 1: Vacation days = (A5 / 365) * 10 Else: Vacation days = 10 + (INT(A6) - 1) capped at 20.
Better: Aguinaldo covers Jan 1 – Dec 31 of year of termination. If termination mid-year: