Hi,
If I give the DOJ the applicable leave for that particular employee, it should calculate automatically. For example, if the DOJ is 15-Jul-2013, from this date to December, I should calculate the applicable leave. Per month, we decide to assign 1.5 days of leave. Can anyone help me calculate this in Excel?
From India, Bangalore
Acknowledge(0)
Amend(0)
8If I give the DOJ the applicable leave for that particular employee, it should calculate automatically. For example, if the DOJ is 15-Jul-2013, from this date to December, I should calculate the applicable leave. Per month, we decide to assign 1.5 days of leave. Can anyone help me calculate this in Excel?
From India, Bangalore
Acknowledge(0)Amend(0)
Hi, What exactly you want to do? Give proper explanation and attach your file for example
From United Kingdom
Acknowledge(0)Amend(0)
From United Kingdom
Acknowledge(0)Amend(0)
I attached excel file for eg. i did calculations manually. i want to use formula that leave applicable column
From India, Bangalore
Acknowledge(0)Amend(0)
From India, Bangalore
Acknowledge(0)Amend(0)
Hi,
Please provide an explanation as to why you add 1 in this formula: =6*1.5+1. Alternatively, you can use the formula =COUNT(I6:N6)*1.5 after creating an attendance tracker. Once the tracker is set up, you can calculate this formula. You may also refer to the attached file for further information.
Thank you.
From United Kingdom
Acknowledge(0)Amend(0)
Please provide an explanation as to why you add 1 in this formula: =6*1.5+1. Alternatively, you can use the formula =COUNT(I6:N6)*1.5 after creating an attendance tracker. Once the tracker is set up, you can calculate this formula. You may also refer to the attached file for further information.
Thank you.
From United Kingdom
Acknowledge(0)Amend(0)
Dear Gayathri,
Just to help you, first of all, if a person has joined on 15th July 2013, he will complete 6 months on 15th Jan '13. Until then, the accumulated leave as per your instruction is that in one month, the leave will be 1.5, totaling 9 days.
In your chart, you have taken 22nd July as the date of joining. Why is that? It should be the 15th as mentioned by you. Then, you have to carry forward the leave every month after deducting the leaves taken each month. Finally, as shown in the chart, he will be left with only one day of leave. Also, you are only considering paid leave; sick and casual leave are fixed as per the company policy.
For paid leave, for every 20 days worked, you earn 1 leave. In the chart, you will need to account for all types of leaves, including LWP (Leave Without Pay) and any other leave policies that your company follows. I will try to attach your file back with some modifications.
From India, Visnagar
Acknowledge(0)Amend(0)
Just to help you, first of all, if a person has joined on 15th July 2013, he will complete 6 months on 15th Jan '13. Until then, the accumulated leave as per your instruction is that in one month, the leave will be 1.5, totaling 9 days.
In your chart, you have taken 22nd July as the date of joining. Why is that? It should be the 15th as mentioned by you. Then, you have to carry forward the leave every month after deducting the leaves taken each month. Finally, as shown in the chart, he will be left with only one day of leave. Also, you are only considering paid leave; sick and casual leave are fixed as per the company policy.
For paid leave, for every 20 days worked, you earn 1 leave. In the chart, you will need to account for all types of leaves, including LWP (Leave Without Pay) and any other leave policies that your company follows. I will try to attach your file back with some modifications.
From India, Visnagar
Acknowledge(0)Amend(0)
Thank you for your help. I posted the sample data. I can't reveal the original data. I'm attaching a sheet without employees' names and employee numbers. I have found the formula. Please correct me if I'm wrong.
From India, Bangalore
Acknowledge(0)Amend(0)
From India, Bangalore
Acknowledge(0)Amend(0)
Hi,
According to our policy, yearly leave is 20 days. I want to divide it into every month (1.67 days). If the employee does not take leave in a particular month, I would like to carry forward that leave to the next month. I need to do this for every month in a year based on their joining date. Finally, I want to calculate the total leave taken.
I hope I have explained it correctly. Please assist me with this.
Thank you.
From India, Bangalore
Acknowledge(0)Amend(0)
According to our policy, yearly leave is 20 days. I want to divide it into every month (1.67 days). If the employee does not take leave in a particular month, I would like to carry forward that leave to the next month. I need to do this for every month in a year based on their joining date. Finally, I want to calculate the total leave taken.
I hope I have explained it correctly. Please assist me with this.
Thank you.
From India, Bangalore
Acknowledge(0)Amend(0)Engage with peers to discuss and resolve work and business challenges collaboratively - share and document your knowledge. Our AI-powered platform, features real-time fact-checking, peer reviews, and an extensive historical knowledge base. - Join & Be Part Of Our Community.
SALARY SHEET CALCULATION.xls