LinkBack URL
About LinkBacks
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.
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.
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.
Thank you Mr. John for your response. Attached the worksheet that i need to fill in.
What are the criteria for EOS gratuity entitlement?
Please explain the criteria and add sample results to your file.
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)
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
Hi
Greetings
Can you please assist me for the Uae gratuity formula in excel
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.
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help. It's a universal courtesy.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
NB: as a Moderator, I never accept friendship requests.
Forum Rules (updated August 2023): please read them here.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks