Calculo De Prestaciones Honduras Excel Info

Simpler: Use DATEDIF for complete months.

Actually, legal method: Aguinaldo = (Salary × 30 days) ÷ 12 months × months worked.

Proportional formula (less than 1 year): [ \textVacation days = \frac\textDays worked365 \times 10 ] Then multiply by daily salary:

Formula: =IF(A6 < 1, (A5/365)*10, MIN(10 + INT(A6)-1, 20)) * A8 Proportional for calendar year of termination. calculo de prestaciones honduras excel

But by law: each full month = 1/12 of monthly salary. So formula:

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

Indemnización = 666.67 × 20 × 2.205 = L 29,400 Cap = 240,000 → no cap issue Simpler: Use DATEDIF for complete months

Days worked = 805 Years = 2.205 Daily salary = 666.67

This is a practical guide to calculating in Honduras using Excel.

But if terminated Dec 31, it’s full A7. But by law: each full month = 1/12 of monthly salary

Formula: =Aguinaldo = (B1/12) * months worked in calendar year.

Months worked = (End date – DATE(YEAR(End date), 1, 1) + 1) / 30.44.

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 |

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.