FREE HOURLY WORK SCHEDULE TEMPLATE CODE

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.

Free hourly work schedule template