I have modified the leave calculation as per information received from our seniors and discussions posted here. This will calculate your leave automatically. Some fields here are mandatory to calculate according to your organization.
Regards
From India, Mumbai
Acknowledge(1)
Amend(0)
7Regards
From India, Mumbai
Acknowledge(1)Amend(0)
I have made a few more modifications and am posting here to save others time. The seniors have helped me a lot by sharing valuable information on different topics. Therefore, I also want to assist my new friends. If anyone has a better calculation, please post it here so that I do not need to spend time on modifications and can obtain the formula to save time.
Thanks,
Anjani Singh
From India, Mumbai
Acknowledge(0)Amend(0)
Thanks,
Anjani Singh
From India, Mumbai
Acknowledge(0)Amend(0)
Thank you for your comments. I noticed that the forwarded leave's cell is not displaying the value properly (the calculation done through it is okay). I have updated it to show it correctly. Apologies for the oversight.
Thanks
Regards
From India, Mumbai
Acknowledge(0)Amend(0)
Thanks
Regards
From India, Mumbai
Acknowledge(0)Amend(0)
Dear Anjani,
Kindly provide me with the password for the leave calculation as the current sheet is protected, and I am unable to modify it. It is very useful; the only thing I have to do is adjust it according to the Kuwait Labour Law.
Regards,
[Your Name]
From Kuwait, Kuwait
Acknowledge(0)Amend(0)
Kindly provide me with the password for the leave calculation as the current sheet is protected, and I am unable to modify it. It is very useful; the only thing I have to do is adjust it according to the Kuwait Labour Law.
Regards,
[Your Name]
From Kuwait, Kuwait
Acknowledge(0)Amend(0)
Automatic Leave Calculation Update
Automatic leave calculation has been updated again. You can set your own values according to your company norms (default values are set). If there's any problem regarding its calculation, please write or email at [Email Removed For Privacy Reasons].
Thanks,
Anjani Singh
From India, Mumbai
Acknowledge(1)
Amend(0)
Automatic leave calculation has been updated again. You can set your own values according to your company norms (default values are set). If there's any problem regarding its calculation, please write or email at [Email Removed For Privacy Reasons].
Thanks,
Anjani Singh
From India, Mumbai
Acknowledge(1)Amend(0)CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.
LEAVE ENCASHMENT NOT INCLUDED IN WAGES FOR P. F. CALCULATION.pdf
Leave Encashment & Salary Calculation.xls x