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.
This is a practical guide to calculating in Honduras using Excel.
= 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
Total prestaciones = 29,400 + 7,466 + 4,167 = L 41,033 | Cell | Value / Formula | |------|------------------| | B1 | 20000 | | B2 | 01/01/2022 | | B3 | 15/03/2024 | | B4 | =B3-B2+1 | | B5 | =B4/365 | | B6 | =B1/30 | | B7 | =MIN(B6 20 B5, B1*12) | | B8 | =MIN(10+(B5-1)*1,20) B6 | | B9 | =(B1/12) (MONTH(B3)-1+DAY(B3)/30) | | B10 | =B7+B8+B9 | calculo de prestaciones honduras excel
Formula: =IF(A6 < 1, (A5/365)*10, MIN(10 + INT(A6)-1, 20)) * A8 Proportional for calendar year of termination.
Months worked this year = (End date – Date(year(end),1,1) + 1) / 30.44 approx.
For partial year: Years worked = Total days worked / 365 (exact). In Excel: =MIN(A8 * 20 * A6, A7
Actually, legal method: Aguinaldo = (Salary × 30 days) ÷ 12 months × months worked.
For calculation: use Vacation days = 10 + (years-1)*1 (if years>1), max 20. Then multiply by daily salary.
Example: March 15 → (2 + 15/30) = 2.5 months. Months worked this year = (End date –
Let’s do it simpler: Aguinaldo = (A7 / 12) * months worked in termination year.
Aguinaldo: (20000/12) × (2 + 15/30) = 1666.67 × 2.5 = L 4,166.67
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