But that’s overcomplicating. Legal: Less than 1 year: proportional 10 days. More than 1: 10 days first year + 1 extra per year after, cap 20 per year, but you can only take 20 days in a year.
[ \textAguinaldo prop. = \frac\textMonthly salary12 \times \textMonths worked in the year (including fraction) ]
So formula: =ROUND((A7/12) * (MONTH(C3)-1 + DAY(C3)/30), 2) = Aguinaldo + Vacaciones + Indemnización 3. Example calculation (March 15, 2024 termination) Start: Jan 1, 2022 End: March 15, 2024 Salary: L 20,000
Example end date March 15 = 3.5 months.
Formula: =IF(A6 < 1, (A5/365)*10, MIN(10 + INT(A6)-1, 20)) * A8 Proportional for calendar year of termination.
Daily salary = Monthly salary ÷ 30. 20 days salary per year worked. Max: 12 months of salary.
Example: March 15 → (2 + 15/30) = 2.5 months. calculo de prestaciones honduras excel
Months worked this year = (End date – Date(year(end),1,1) + 1) / 30.44 approx.
But for indemnización: years worked exact. Actually, easier to build:
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. But that’s overcomplicating
Indemnización = 666.67 × 20 × 2.205 = L 29,400 Cap = 240,000 → no cap issue
Aguinaldo = (A7/12) * 2.5.
This is a practical guide to calculating in Honduras using Excel. [ \textAguinaldo prop