Prestaciones Honduras Excel — Calculo De

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

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.

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

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

But if terminated Dec 31, it’s full A7.

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

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