Calculo De Prestaciones Honduras Excel Instant

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

So: =MIN(10 + (A6-1)*1, 20) * A8

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

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

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

Better: = (A7/12) * ( (MONTH(End date) - 1) + DAY(End date)/30 )

[ \textVacation pay = \textDaily salary \times \textVacation days owed ]

Then compare to cap: Cap = Monthly salary × 12. If indemnización > cap, use cap. Step 1: Input data cells | A | B | C | |---|---|---| | Monthly salary (Lempiras) | 20,000 | | | Start date (dd/mm/yyyy) | 01/01/2022 | | | End date (dd/mm/yyyy) | 15/03/2024 | | | Days worked total | =C3-C2+1 | | | Years worked | =C4/365 | | | Daily salary | =B1/30 | | Step 2: Aguinaldo Months worked in last year (Jan to Dec proportional? No – Aguinaldo is per calendar year worked.)

For calculation: use Vacation days = 10 + (years-1)*1 (if years>1), max 20. Then multiply by daily salary.

[ \textAguinaldo = \textMonthly salary \times \frac\textDays worked in year365 ]

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

Actually, simpler: vacation days owed = MIN(10 + (INT(years)-1), 20) + (MOD(years,1)*10) capped total 20.

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