Hi There, I am a new Intern in HR & works for a MSME Organization. I have been asked to create attendance report along with every month leave balances to be reflected in the same sheet. I need an assistance in understanding that how I can create such sheet & using which formulas. I have tried the same but its not getting through. Attached is the sheet I was trying to make. Below are the points I want in the sheet:
1. It should reflect every month leave balance.
2. Every Month sheet should have limitation that the employee if takes leave above the monthly allotted ( i.e 1 Leave/Month) then leave paid days attendance calculation will be done automatically.
3. All months should be interlinked in attendance.
Requesting the qualified professionals to please assist with the same.
From India, Indore
11. It should reflect every month leave balance.
2. Every Month sheet should have limitation that the employee if takes leave above the monthly allotted ( i.e 1 Leave/Month) then leave paid days attendance calculation will be done automatically.
3. All months should be interlinked in attendance.
Requesting the qualified professionals to please assist with the same.
From India, Indore
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.
How to create Attendance Register.xls
Create bell curve in XL.doc