Hi,

I am in UAE and the gratuity calculation takes a long time.

to solve this i am attaching the law

which is

if less than an year than no gratuity
if 1 to 5 years its on 21 days Basic
if more than 5 years 30 days basic

the catch is that the remaining number of days have to be calculated as well, so the calculation takes place in Days. as well as if the person is on 6 years the first 5 have to be on 21 days.

I would be really grateful if someone can solve this for me preferably in an excel.

Best Regards,

Harris