Calculo De Prestaciones Honduras Excel (2025)

Better for Excel:

For partial year: Years worked = Total days worked / 365 (exact).

Months worked this year = (End date – Date(year(end),1,1) + 1) / 30.44 approx.

Aguinaldo = (A7/12) * 2.5.

But for indemnización: years worked exact. Actually, easier to build:

But that’s messy. Let’s do precise:

Then Vacation pay = Vacation days * A8.

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

= 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

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. calculo de prestaciones honduras excel

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.

Let’s do it simpler: Aguinaldo = (A7 / 12) * months worked in termination year.

Simpler: Use DATEDIF for complete months. Better for Excel: For partial year: Years worked