Gratuity Calculation in Excel
I have Attached Gratuity Calculation Tool
Gratuity Calculation | ||||
Name of the Employee | : | ASD | ||
Father’s/Husband’s Name | : | ZXC | ||
Date of Birth | : | 7/1/1965 | ||
Date of Joining | : | 5/1/2005 | ||
Date of Separation | : | 10/30/2011 | ||
Last Drawn Basic Salary | : | 5000.00 | ||
Last Drawn D.A | : | 0.00 | ||
No.of years served | : | 6 | (Roundup nearest 1 Year) | |
Gratuity Amount | : | 17308.00 |
Click Here To Download Gratuity Calculation Tool