Uae Gratuity Formula In Excel

Hi,Nowadays, most companies work only 22 days in a month. In this case, employees will receive more Gratuity. Is the 26th common for all companies, or will it differ based on the company?Please provide clarity on this subject.

Hi Venkat,If an employee worked for 5 years and 8 months, then you have to consider 6 years as the number of completed years of service.Formula for Calculation: Last Basic / 26 X 15 X 6.

Can someone please share the exact formula with explanations for 1) limited contract and 2) unlimited contract? Also, how is gratuity calculated from probation to 1 year, from 2 to 3 years, and from 3 to 5 years, and so on! This is urgent, please.

Please clarify how to calculate the number of years worked for gratuity.For example, if someone has worked for 5.5 years, how many years should be considered for calculation and payment of gratuity? What is the exact concept behind this calculation? Please provi...

My name is Jitendra. I have been working in the company for almost 9 years and 8 months. My basic salary is 7200\. How can I calculate my gratuity? Please calculate my gratuity and email me at my email id.

Hello Pawarmohan,Here is the Excel format of the Gratuity Calculator.Regards

One of my employees' date of joining is 02/10/2009, and the date of leaving is 31/03/2016\. Kindly verify the year of gratuity.

Hi Chief,Any luck? I'm looking for the same, and I hope someone can help me out with a Gratuity Calculator.Regards,Mark