Calculo De Prestaciones Honduras Excel -

For partial year: Years worked = Total days worked / 365 (exact).

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

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