Simpler: Use DATEDIF for complete months.
But for indemnización: years worked exact. Actually, easier to build:
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 calculo de prestaciones honduras excel
Example end date March 15 = 3.5 months.
= 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 Simpler: Use DATEDIF for complete months
Example: March 15 → (2 + 15/30) = 2.5 months.
For 2.2 years: 10 + 1.2 = 11.2 days → L 7,466. Example calculation (March 15, 2024 termination) Start: Jan
[ \textAguinaldo prop. = \frac\textMonthly salary12 \times \textMonths worked in the year (including fraction) ]