Calculo De Prestaciones Honduras Excel Site

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

= 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

For 2.2 years: 10 + 1.2 = 11.2 days → L 7,466.

[ \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.

Example end date March 15 = 3.5 months.

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

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

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 |

But by law: each full month = 1/12 of monthly salary. So formula: After 1 year: 10 days/year + 1 day per year up to 20 days

Aguinaldo: (20000/12) × (2 + 15/30) = 1666.67 × 2.5 = L 4,166.67

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