Calculo De Prestaciones Honduras Excel -

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

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

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

Then Vacation pay = Vacation days * A8.

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

Indemnización = 666.67 × 20 × 2.205 = L 29,400 Cap = 240,000 → no cap issue

[ \textAguinaldo = \frac\textMonthly salary12 \times \textMonths worked (proportional) ] Honduras: 10 days vacation after 1 year (for first year: proportional). After 1 year: 10 days/year + 1 day per year up to 20 days. calculo de prestaciones honduras excel

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

Months worked in that year = month number of end date.

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 | Better: = (A7/12) * ( (MONTH(End date) -

Better for Excel:

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

Actually, simpler: vacation days owed = MIN(10 + (INT(years)-1), 20) + (MOD(years,1)*10) capped total 20. Proportional formula (less than 1 year): [ \textVacation