Hi,
if i give DOJ the applicable leave for that particular employee should calculate automatically.
for eg., DOJ is 15-jul-2013 from this date to dec i should calculate applicable leave. Per month we decide to assign 1.5 days leave.
can anyone help me to calculate in excel.
From India, Bangalore
8if i give DOJ the applicable leave for that particular employee should calculate automatically.
for eg., DOJ is 15-jul-2013 from this date to dec i should calculate applicable leave. Per month we decide to assign 1.5 days leave.
can anyone help me to calculate in excel.
From India, Bangalore
I attached excel file for eg. i did calculations manually. i want to use formula that leave applicable column
From India, Bangalore
From India, Bangalore
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.
Till then the accumulated leave as per your instruction that in one month the leave will be 1.5. the total will be 9 days.
In your chart you have taken 22nd July as DOJ why. it should be 15th as mentioned by you. Then you have to carry forward the leave every month after deducting the leaves taken every month. Finally as shown in chart he will be left with only one day leave. Also this you are taking only paid leave. Sick and Casual leave are fixed as per the company policy.
For Paid leave, 20 days working you earn 1 leave. In chart you will have to accommodate all kind of leaves. Also LWP (Leave without pay), and the other leaves that your company follow. I am try to attach your file back with some modifications.
From India, Visnagar
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.
Till then the accumulated leave as per your instruction that in one month the leave will be 1.5. the total will be 9 days.
In your chart you have taken 22nd July as DOJ why. it should be 15th as mentioned by you. Then you have to carry forward the leave every month after deducting the leaves taken every month. Finally as shown in chart he will be left with only one day leave. Also this you are taking only paid leave. Sick and Casual leave are fixed as per the company policy.
For Paid leave, 20 days working you earn 1 leave. In chart you will have to accommodate all kind of leaves. Also LWP (Leave without pay), and the other leaves that your company follow. I am try to attach your file back with some modifications.
From India, Visnagar
Thank you for your help. I posted the sample data. I cant reveal the original data. Im attaching sheet with out employees name and employee number. i have found the formula . pls correct me if im wrong.
From India, Bangalore
From India, Bangalore
Hi ,
According to our policy yearly leave is 20 days. And i want to divide it into every month (1.67). If the employee is not taking leave in that month i want to carry forward that leave to next month, like this i have do it for every month in a year according to their joining date and last i want to calculate the total leave.
Hope i explained correctly. Please help me on this.
From India, Bangalore
According to our policy yearly leave is 20 days. And i want to divide it into every month (1.67). If the employee is not taking leave in that month i want to carry forward that leave to next month, like this i have do it for every month in a year according to their joining date and last i want to calculate the total leave.
Hope i explained correctly. Please help me on this.
From India, Bangalore
Community Support and Knowledge-base on business, career and organisational prospects and issues - Register and Log In to CiteHR and post your query, download formats and be part of a fostered community of professionals.
SALARY SHEET CALCULATION.xls