Calculo De Prestaciones Honduras Excel -

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

Simpler: Use DATEDIF for complete months.

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

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

[ \textIndemnización = \textDaily salary \times 20 \times \textYears worked (proportional) ]

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

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