Dnyan2001
Ms Excel
Gayathri Kalidasan
Human Resource
+1 Other

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.
29th October 2013 From India, Bangalore
Hi, What exactly you want to do? Give proper explanation and attach your file for example
29th October 2013 From United Kingdom
I attached excel file for eg. i did calculations manually. i want to use formula that leave applicable column
29th October 2013 From India, Bangalore

Attached Files
Membership is required for download. Create An Account First
File Type: xls Leave Calculation.xls (19.0 KB, 2194 views)

Hi,
Give me the explanation that why you add 1 in this formula =6*1.5+1.
Or you can use =COUNT(I6:N6)*1.5 this formula but first you have to make attendance tracker for this then you calculate this formula.
Or check attached file
29th October 2013 From United Kingdom

Attached Files
Membership is required for download. Create An Account First
File Type: xls Attendance Tracker.xls (2.96 MB, 1642 views)

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.
31st October 2013 From India, Visnagar

Attached Files
Membership is required for download. Create An Account First
File Type: xls Leave%20Calculation.xls (34.5 KB, 1046 views)

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.
31st October 2013 From India, Bangalore

Attached Files
Membership is required for download. Create An Account First
File Type: xls Leave Checklist.xls (29.5 KB, 1115 views)

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.
7th November 2013 From India, Bangalore
Add Reply Start A New Discussion

Cite.Co - is a repository of information created by your industry peers and experienced seniors. Register Here and help by adding your inputs to this topic/query page.
Prime Sponsor: TALENTEDGE - Certification Courses for career growth from top institutes like IIM / XLRI direct to device (online digital learning)





About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service



All rights reserved @ 2019 Cite.Co™