Excel formula for computing no. of days entitlement for gratuity in uae?

[Virginia5611]

Kindly assist to give me formula for computing no. of days entitlement for gratuity in uae for my report for EOS provisions? Appreciate your help pls.

[JohnTopley]

We need a lot more information than you have supplied.

Attach a sample workbook (not image).

Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate.

Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[Virginia5611]

Thank you Mr. John for your response. Attached the worksheet that i need to fill in.

[JohnTopley]

What are the criteria for EOS gratuity entitlement?

Please explain the criteria and add sample results to your file.

[avk]

Every employee who completes the 5 years in one service is eligible for the gratuity under law.
The gratuity calculation is : Basic Salary x No. of years service x 15 / 26
For examble:
A person worked for 6 years and his basic 10000/- then the gratuity amount comes to Rs.10000/- x 8 x 15 / 26 = Rs.46,153.85/-
15 is meant for half month salary
26 is meant for month days (after leaving w/offs)

[riyasnm]

Hi

Greetings

Can you please assist me for the Uae gratuity formula in excel

[AliGW]

Welcome to the forum!

Unfortunately your post does not comply with Rule 2 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.