Employee Leave Management

Posted on 2010-01-07
Last Modified: 2012-05-08

I would like have Expert advice on how to capture employees Medical Leave (MC), Emergency Leave (EL) and Annual Leave (AL) effectively. I tried to find an Excel template in Net but couldnt find a proper one. If Expert has a sample template please share with me.
Question by:Theva
    LVL 17

    Expert Comment

    There are many payroll software programs that could do this. The function you seek is integrated into the payroll software.

    Are you not aware of this or is purchasing such software a hardship?

    If so, I can see how you could keep track of this in an Excel spreadsheet easily, but you would probably have to make your own.

    Author Comment

    Hi Tiras 25,

    Thanks for your feedback, yes I do aware such product like People Soft, but believe me, its too expensive. At present I prefer to use excel template. Last year I've created an excel sheet to capture this, but its not really helpful to track this. I've attached the excel sheet that I've used last year. Hope you can give me some idea how revive this template and tracks the MC,ML and AL more effectively.  
    LVL 17

    Accepted Solution

    By googling employee absence calendar, I found this paper form, good for at-a-glance assessment of employee attendance -

    And here is a Microsoft excel template for 2010, I didn't open it but it may help you get started -

    Author Closing Comment

    Thanks a lot Tiras

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    A2 = A1 That kind of cell reference is relative.  If you copy it from A2 to B2, then B2 will get this: B2 = B1 That's all fine and good, but if you then insert a new row above row 2, you'll find: A3 = A1 B3 = B1 This is intentional. …
    I've recently been in need of an Excel macro that could add a letter before the text on multiple cells in an Excel document. My English is as it is, so I will try explain what it does diffrently. If you have an excel document with 2000 rows an…
    The viewer will learn how to simulate a series of sales calls dependent on a single skill level and learn how to simulate a series of sales calls dependent on two skill levels. Simulating Independent Sales Calls: Enter .75 into cell C2 – “skill leve…
    This Micro Tutorial will demonstrate the scrolling table in Microsoft Excel using the INDEX function.

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now