Home › Masrofna Store › UAE Gratuity Calculator (Excel)
UAE Gratuity Calculator (Excel)
Federal Decree-Law 33/2021 — 21 and 30 days per year, two-year cap, unpaid leave deducted.
Enter basic salary, start and end dates and any unpaid leave. The sheet applies the 21-days-per-year tier for the first five years, 30 days after, the 24-month cap, and shows the gratuity due. Notes explain what counts as wage, the one-year threshold and the free-zone exceptions. Formulas only.
Read before you buy
- How to calculate gratuity amount in the UAE: the figure earned so far, month by month, on one basic salary
- How to calculate end of service: the calculator steps, worked on one UAE salary from 1 to 20 years
- Gratuity calculator India 2026: which formula applies to an Indian employee in the UAE, worked on one salary
- Gratuity calculation in the UAE: has anything changed? The formula, the savings scheme and one raise worked both ways