![]() ![]() Columns NL to NU gives the leave break-up by leave code (for the entire year).It counts the leaves on working days only (those on weekends and/or holidays are not counted). UPDATED: Column NK (highlighted in light red in the pic below) has the number of annual leaves taken by an employee.Column NJ (highlighted in green in the pic below) has the number of leaves of that employee in that month.If that day is a weekend or holiday, the color would not change. As soon as you enter the leave code for any employee, it gets highlighted in red (in the case of half-day, it gets highlighted in yellow).you can enter H1 or H2 for a half-day leave. There are two codes reserved for half-day leaves.For example, in the case of sick leave, use S, in the case of Vacation, use V, as so on. To enter the leave record for employees, use the relevant codes based on the leave type (you can customize these leave codes). ![]() It will automatically be reflected in the tracker by highlighting those days in Orange color. You can update the holiday list in the worksheet named “Holiday List”.As soon as you specify the non-working days, those weekdays get highlighted in gray color in the leave tracker.If you select No, that day is marked as a non-working day in the leave tracker. At the right of the leave tracker, there is functionality to specify the working days by selecting Yes from the drop-down. You can specify the working days and non-working days (Weekends).Use the triangle icons next to the month names to go to the next/previous month and mark leaves. DO NOT use Cell A1 to move to the next month while recording leaves. Note:The value in cell A1 is to change the time period of the leave tracker ONLY.For example, if you follow the April-March cycle, select April 2023 as the starting month. You can select a start month and can track leaves for a year. This Excel template can be used to track leaves for over a year.It shows you the selected month only and hides all the other months. There is a short VBA code that runs in the background whenever you change the month. Use the triangle icons next to the month name to move to the next/previous month (the template updates itself to show the dates for the selected month).How this Excel Leave Tracker Template Works? Looking for the Google Sheets version of this Leave Tracker Template? Click here! It uses a bit of conditional formatting, a few DATE functions, array formulas, and a simple VBA code.ĭownload the Excel Leave Tracker Template (tracking for 20 employees/people) It also provides a monthly and yearly total of different types of leaves that can be helpful in project planning and leave management. You can track 10 different leave codes for an employee – vacation leaves, sick leaves, maternity/paternity leaves, casual leave tracking, leave in lieu of overtime, and half days, etc. This Excel Leave Tracker template can be used to record and monitor employee leaves for a year (of a financial year where you can choose the starting month of the year). You can also use this as a vacation tracker template or student attendance tracker if you want. So, I created this Excel Leave Tracker Template to make leaves management easy and track monthly and annual leaves by her team members. Till now, she used a simple Gantt chart in Excel but wanted something better with more functionalities. This tracker template is then used to track vacations/holidays and planned leaves of the team members. One of my teammates has the responsibility of creating a leave tracker template in Excel for the entire team. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |