Indzara
Shop
Support
Login

2025 Leave Tracker & Vacation Tracker Excel Template

Introducing the Leave Tracker Excel template – Your Ultimate Solution for Streamlined Leave Management!

Are you a HR Manager, a Small Business Owner, or a Project Manager? Regardless of your role, if you’re tasked with managing employee leave, vacations, and time off, this Free Leave Tracker Excel template is your essential tool for efficient and organized leave management.

This Excel template is designed for Microsoft Excel, but if you are looking for a Google Sheet template, please visit Employee Leave Vacation Tracker in Google Sheets.

Here is a sample of Leave Tracker dashboard you can create instantly using this Excel Template.

Leave Tracker 2025 – Team Dashboard

Features of Employee Leave Tracker Excel Template

The following are the highlights of the template.

  • Customize settings to meet your business needs
    • Track 5 types of employee leave (For up to 12 leave types, try Employee Leave Manager template)
    • Customize which days are weekends (not working days)
    • Account company holidays
  • Practical Features
    • Track vacation for multiple employees
    • Employees can have start dates and termination dates
    • Can handle partial days of leave
  • Ease of Use
    • Easy to enter Leave in ranges of dates
    • Easy to customize colors to suit your preferences
    • Can use the template continuously for many years (keep all your data organized in one file :))
  • Automated Calculations
    • Fully Automated Vacation Tracker Dashboard with monthly calendar view
    • Calculates Worked Days automatically
    • Automated Annual Employee attendance report

Downloads

Download Employee Leave (Vacation) Tracker 2025
Download Employee Leave (Vacation) Tracker 2025 with Sample Data

Do check our Employee Leave Manager in Excel for additional features

How to use the Leave Tracker Excel Template

The template has 5 visible sheets. (Settings, Employees, Leave, Team Dashboard, Employee Report).

Here is the overview of steps to use the template.

  • Enter Leave Types, Select Weekends and Enter Holidays in the Settings sheet
  • Enter list of employees in Employees sheet
  • Enter leave data for employees in Leave sheet
  • Choose a month and view vacation calendar for the team in Team Dashboard sheet
  • Choose an employee and view/print annual employee attendance report in Employee Report sheet

Detailed Steps

Now, let’s see the steps in more detail.

Before we begin, if you are new to Excel tables, please read Introduction to Excel Tables for data entry. Data entry in all our templates use Excel tables and a quick introduction to that will get you going in the correct direction. 

Step 1: Enter up to 5 types of leave to suit your company

The template by default supports 5 types of categorizing your leave. Since different companies may have different names and different number of leave types, the template supports customizing them.

Enter 5 types of Employee Leave types to suit your business
Enter 5 types of Employee Leave types to suit your business

By default, you will see the leave types (Vacation, Sick, Unpaid, Half Day, Other). You can just type over these names and replace with your own preferred names.

How to handle half-day leaves

You can see that there is an option to assign ‘Day Value’ to each leave type. This setting is present to handle partial days of leave. For example, I have entered 0.5 for ‘Half Day’ leave type. That means that when an employee takes Half Day leave, template will add 0.5 to leave taken total and reduces the Worked days by 0.5.

If your company allows 2 hours leave in an 8 hour workday setup, that would be 0.25 day. You can create a leave type and enter 0.25 as ‘Day Value’.

Step 2: Select your company Weekends

In order to calculate attendance of employees automatically, we need to know company weekends so that we can remove them from working days.

Select Company Weekends to use for employee attendance tracking
Select Company Weekends to use for employee attendance tracking

Since our goal is to provide a global solution to vacation tracking, we have the option of selecting any combination of weekend days. In the screenshot above, I have chosen Sunday as Weekend.

So, this tells the template to do 3 things.

  1. Template will highlight Sundays visually differently on the vacation dashboard
  2. While calculating attendance, it will not include the Sundays as Working days.
  3. Sundays will also not get counted as leave.  When an employees takes Thursday to Monday as Vacation, it will count only as 4 days of leave (Thu, Fri, Sat, Mon).

Step 3: Enter company holidays

Enter list of holidays in your company.

Enter Company Holidays for 2025

The template will treat the holidays similar to Weekends for calculation purposes, but holidays will be displayed in a different color on the calendar. This allows us to view holidays and weekends distinctly.

Step 4: Enter Employees’ data

Now, we move to the Employees sheet.

Enter Employee Name, Start Date and Termination Date (optional)

We will enter the Employee Name, Start Date (date when the employee began employment) and then Termination Date (if applicable). The Start Date and Termination Date allow the template to calculate the count of working days for each employee correctly.

Since the template can help you manage leave for multiple employees for long term windows (even many years, as there is no limit ), it is quite possible that new employees join the company and current employees may leave. I want the template to work smoothly for you even when that happens.

Step 5: Enter Employee Leave Data

Now, for the last data entry section, we move to the Leave sheet.

We enter leave taken by each employee here. There are four fields (Employee Name,  Leave Start Date, Leave End Date and Leave Type) in this table.

Enter Employee Leave Data – Employee Name, Leave Start Date, Leave End Date and Leave Type

If an employee takes a 5 day vacation, you can enter that in one row by providing Leave Start and Leave End dates.

If an employee takes a single day leave, please enter same date in Start Date and End Date fields.

Leave Type field has data validation built-in which shows the 5 options we set in the Settings sheet.

Leave Type - Drop down options for data entry
Leave Type – Drop down options for data entry

We are done with data entry. It’s time to see the template’ magic in creating the vacation calendar and report.

Step 6: View Team’s Monthly Leave Dashboard

The dashboard is interactive as it allows the user to choose the month for which we want to view the leave data for. We will enter the month by selecting Year and Month.

There are two pages in this Dashboard sheet. First is the leave calendar view.

Leave Tracker 2025 – Team Dashboard

As you can see from the above screenshot, the leave types are shown in different color. The legend is shown at the top indicating what each color means. In addition to the 5 leave types, we also have display for the following: Holidays (purple), Weekends (Dark Gray), Not Employed (Dot pattern) and Not Applicable (Diagonal Line pattern).

Order of priority for colors: Not Applicable > Not Employed > Holidays > Weekends > leave types

Holidays and Weekends are self-explanatory. Not Employed will represent the days before the employee began employment and days after the employee termination date (if applicable).

You can use this calendar view to assess if you will have enough coverage in your team for specific weeks (for example, during the holiday season). 

Monthly Summary

This sheet also shows the monthly summarized count of days taken off under each leave type, total leave taken and Worked Days.

Leave Tracker 2024 Team Dashboard – Summary of Leaves

Total Leave is the sum of leave taken under each of the 5 leave types.

If an employee’s leave overlaps with a holiday or a weekend, it does not count as a leave day.

Worked Days is calculated as (Company Working days – Holidays – Weekends – Not Employed Days – Total Leave days)

Worked days represents the number of days an employee worked or is scheduled to work.

You can look at this view during the last week of a month, to calculate the next month’s capacity (in work days) for the entire team. This will be helpful to evaluate whether you have enough capacity to meet the demand (work) ahead in the next month.

Step 7: View Annual Employee Attendance Report

While the previous sheet was about viewing all employees at once in a calendar view one month at a time, we also need to see one employee’s data across months. This is where the Employee Report comes in handy.

Here we have three inputs.

Select year, Employee name and Starting Month

The Year and Employee Name selections should be easily understandable.

The report has the flexibility to allow you to choose the Starting Month from which you need the report to be generated. Once these inputs are chosen, the template automatically calculates the End Date. This is based on whether the employee is no longer with the organization, then the termination date is considered the End Date or the latest date in the Report is considered End Date.

That is, in the above example, the End Date is the last date of the current Employee Report for Clark since he is still with the organization.

This sheet has 2 pages as well. First, the calendar view.

Employee Attendance – Leave Report showing types of leave, holidays and weekends
Employee Attendance – Leave Report showing types of leave, holidays and weekends

As we discussed with the Team Dashboard, the colors and the legend work the same way. For the chosen employee and year, we can visualize the complete year’s leave patterns.

The second page presents the summarized count of leave and worked days.

Employee Attendance Report – Monthly Summary of leave by type and worked days

EMPLOYEE LEAVE MANAGER

Extensions

How to extend the functionality of the template?

What if I don’t need 5 leave types

No problem. You can just remove additional leave types easily.

In this example, I have selected last 2 rows of the Leave Type table. Then, right click to bring up the menu that you see in the image below.

How to remove leave types if not needed
How to remove leave types if not needed

Click on Delete –> Table Rows.

This will remove the two rows and you will be left with 3 leave types to track for your company. That’s how easy it is. 🙂

How to enable drop down values for Employee Name in the Leave Table?

First, we will extend the table to additional empty rows. Click on the end of the table and drag down.

Click on the end of table and drag down to extend table to more rows
Click on the end of table and drag down to extend table to more rows

Once you do that, the table will look like below, with new empty rows.

New Empty rows in Leave Table
New Empty rows in Leave Table

Now that you have new rows inside the table, the drop downs for both Employee Name and Leave Type will work.

Drop down for Employee name works
Drop down for Employee name works

It is recommended that you add only a few empty rows at a time. The more rows we have, Excel has to process more data when it is performing calculations needed for our dashboard and employee report. This could slow Excel down.

Can I remove employees from the file?

On occasions, you may want to remove an employee’s name from the file if he/she has left the team.

  1. Select the employee’s name in the Employees’ sheet
  2. Right Click and Choose Delete —> Table Rows

You can also remove the employee’s leave data from the Leave sheet, but that is optional.

How can I share this file with my team?

  • Print
    • Press Ctrl+P or select Print from the File menu.
    • Both Team Dashboard and Employee Report are set up ready for printing
  • Export to PDF
    • From the File menu, select Export and click on ‘Create PDF/XPS‘
    • Select the location to store the PDF file on your computer
    • Provide a name to the PDF file and click Publish.
    • You can then email the PDF to your team members or post in your local shared drive.

I don’t like the colors. How can I change them?

Colors are personal preferences. Sometimes, you may want to use your company’s color palette in the documents. Not a problem. Let me explain how you can change the colors used in the template.

As an example, I will show how to change the Holidays color.

Open the Conditional Formatting menu from Home ribbon.

Open Conditional Formatting menu from Home Ribbon
Open Conditional Formatting menu from Home Ribbon

Select ‘This Worksheet’ to show formatting rules used in the current sheet.

Select 'This Worksheet' to see conditional formatting rules used in the sheet
Select ‘This Worksheet’ to see conditional formatting rules used in the sheet

At the top, you will see the rules used to highlight Not Employed, Not Applicable, Weekends and Holidays.

Let’s select the Holiday rule (the purple one) and then click on ‘Edit Rule’.

Select a rule and then click on 'Edit Rule'
Select a rule and then click on ‘Edit Rule’

In the next window, click on Format to choose the new formatting.

Click on Format to change formatting
Click on Format to change formatting

Now, you can see the option to choose a color.

Select Color of your preference and click OK
Select Color of your preference and click OK

Select the color you prefer and click OK. You will need to click OK in the next couple of dialog boxes as well. Now, you should see the holidays represented in a different color.

You can then save the file (Ctrl+S) to save your changes.

In the conditional formatting rules, when you scroll down, you will see the colors used for the 5 leave types.

Conditional Formatting rules for the 5 leave types
Conditional Formatting rules for the 5 leave types

Click on those rules and change colors if needed. The procedure is the same as we did for the Holidays.

How can I edit the formulas? The sheets are protected.

You can unprotect the sheets using indzara as password.

If you are new to this, please read this article on unprotecting/unlocking sheets.

What if I have more than 30 employees?

You can enter more than 30 employees in the Employees sheet. There is no limit imposed here. However, the Team Dashboard shows only 30 employees. To extend that, follow these steps. To support 35 employees,

  • Unprotect the Team Dashboard sheet with the password
  • Select cells B36:AO36 (this is the row of Employee 29)
  • Drag down for 6 rows as to fill them with the formulas.

Now you should see 35 (29+6) employees accounted for.  If you need to extend for more employees, follow the same steps but increase the number of rows you are copying.

If you print or export to PDF, adjust print settings accordingly to include these new additional employees.

How to add calculations such as Attendance %?

You can unprotect the Team Dashboard sheet and add calculations if needed.

For example, if you need to calculate employee’s attendance %, you can follow these steps.

  1. In cell AP8, type =AO8/(AN8+AO8)
    1. This calculates Attendance % as Worked/(Leave+Worked)
  2. Then, select cell AP8 and drag down to fill the cells AP9 to AP37.

This will add a column of Attendance % to the Dashboard.

This was just an example. You can add any other calculations as needed for your company’s needs.

How to create Leave Tracker in Excel

A fully self-paced video course explaining each step in building this template is available.

Course - Vacation and Attendance Tracker Dashboard
Course – Vacation and Attendance Tracker Dashboard
Sign up to learn how to build leave tracker in Excel

I hope this template is useful. If you like it, please share it with your friends. If you have any suggestions or questions around tracking vacation in Excel, please leave them in the comments section. I will continue to enhance this template based on feedback.

695 Comments

  • This Employee Leave Tracker Excel Template for 2025 looks incredibly helpful! I love how user-friendly it seems, and I’m excited to implement it in our HR department. The ability to easily track leave days will definitely streamline our processes. Thanks for sharing!

    Reply

    • Thank you for sharing your valuable feedback. We are glad that you like our Employee Leave Tracker Excel Template.
      Best wishes.

      Reply

  • Would love to have a full year view dashboard, in addition to the monthly, how can I do this?

    Reply

  • Hello! Great work indeed!

    I was just wondering – what if there are 2 leave types that happen in a month?

    For example, two vacation leaves from July 13 to 20 and July 28 to 31.

    Thanks so much! Keep up the great work. 🙂

    Reply

    • Thank you for sharing your valuable feedback. You are welcome.

      You can apply any number of leaves within a month for the same employees with different leave types one below another on the leave table. You can check the same in the sample file.

      But if you want to apply two leave types on the same day for example, half day personal leave and half day casual leave on 15-Jul-2024, it is possible only on the premium template. Following is the link to the same for quick reference:
      https://indzara.com/product/hr-templates/employee-leave-tracker-excel-template/

      Best wishes.

      Reply

    • Thank you for showing interest in our template.

      The template can be used for any year. You need to change the calendar year in cell C4 on Employee Report and cell B3 on Team dashboard.

      Best wishes.

      Reply

  • Hi , I recently came across your Free excel template for employee leave vacation tracker template. This template matched 90 % of my requirement. I have an additional requirement of calculating leaves, present and such data, from dates from 25 to 26. ie, if i’m calculating total leaves, or total sick leave or total present for say april 2024, then i want to calculate from 26th of march 2024 to 25th of april 2024[ instead of calculating from 1st april 2024 to 30 april 2024]. rest all same as per your excel. is there any way to achieve this. ??.

    Reply

  • Hello,

    This is probably a long shot but is there a simple way to just add the vacation days to the Team Dashboard manually?

    Reply

    • Thank you for showing interest in our template.

      No currently you cannot enter the data directly in Team Dashboard. Once you manually enter the data in the Team Dashboard the formula will be removed and changing the month or year will not change the entered value. Also it will not be displayed in employee report.

      Best wishes.

      Reply

  • This is a great help for me as an HR! I’m trying to add more employees (more than 30) and followed the instructions. The formula in the team dashboard appeared in the cells but all are blank for some reason. But when I click the cells, all the formulas are there. But nothings appearing

    Reply

    • Thank you for showing interest in our template and we are glad that our template was helpful.

      In excel duplicating the formulas will work and if you are facing issue please share your sheet at the below link to assist further:
      https://support.indzara.com/support/tickets/new

      In Google Sheets, you will also need to increase the number of rows in “Employee Names” Named range.

      Best wishes.

      Reply

  • Hi, came across your Employees Leave and vacation tracker while I’m trying something for my office. Would like to find out how you create/make changes to the black line at the bottom of your excel table which enables you to drag down for more employees or rows for leave. I’m intending to add some more columns to the left or right. Hope to find out how I can adjust it. Hope to hear from you soon. Thanks

    Reply

  • What if i wanted template to reflect academic year ? July-June instead of January-December

    Reply

  • Hello:

    If I upgrade and purchase the premium template, will all of my data transfer into the new template?

    Thank you!

    Reply

    • Thanks for your interest. Since the premium template is a separate file and has more features, the data does not transfer automatically. However, it is possible to copy paste selected data into the premium template easily. if you need any assistance with transferring, we can help. Please email support@indzara.com
      Thanks & best wishes.

      Reply

  • Hi. I have a situation that our staff entitle their Annual Leave pro-rate basis (8 days for 12 months) regardless their contract in different year. But in this template, it auto counts 16 days AL if the staff join in 2022 and end their contract in 2023. Pls assist. Thank you.

    Reply

  • Hi there,

    I have a situation where in some of our employee is oversea and they have different weekends and holidays. What will be the best option for that?

    Reply

    • Thank you for showing interest in our template.

      Currently, we do not have a leave and vacation tracking template that handles different holidays and weekends. We can take it as a customization project for a fee. Write to us at the below link for estimation:
      https://support.indzara.com/support/tickets/new

      Best wishes.

      Reply

  • How to add another leave type? I would like to one to make it 6 instead of the 5 default leaves.

    Reply

  • Good day

    I have used your template in 2022 and would like to continue to use it this year as all the settings have been customized. However, the template calendar does not seem to update when I enter 2023.

    Please advise on what to do.

    Reply

  • Hello! Thank you for sharing this amazing template with us!

    My workplace has multiple employees who’s hired only for working less that 100%. Their work load may differ from each week. I tried to find a solution to this problem, but i figured that it’s best to ask if you have a solution that may help me with my issue? Or perhaps a different template.

    Best regards from Norway!

    Reply

  • this template is not working with Google sheets when imported. There is a Reference error all over the sheet

    Reply

    • Thank you for showing interest in our template.

      Currently, the features in Excel are not 100% compatible with Google Sheets and vice versa. Hence we have a separate version of the template for Google Sheets. Following is the link to the same for quick reference:
      https://indzara.com/2020/03/employee-leave-vacation-tracker-free-google-sheet-template/

      If you want to work online and offline, then you can upload the Excel template to Microsoft OneDrive an use Excel online, which is similar to Google Drive and Google Sheets. But Google Sheet template will not work offline in Excel.

      Best wishes.

      Reply

  • Also I am trying to change the holidays for 2023 and the password will not unprotect the settings tab but will unprotect other tabs.

    Reply

  • Is there an option to enter the amount of PTO for each employee on their annual PTO report to create a “countdown” from beginning to end of year?

    Reply

  • Greetings. Highly appreciated your template. However, I am running into this issue:
    My input: employee A leaves on 13 Dec. 2022
    The output: employee A leaves for all Dec. 2022, except for 13 Dec. 2022.

    Checked that the date format and other info is correct. Wonder that this is a common issue or not, and how can I fix this issue.

    Thank you very much!

    Reply

    • Thank you for showing interest in our template and sharing your valuable feedback.

      Usually, the data entry error would occur on the start or end date’s year. If both the start and end date has same year, please share your sheet to us from the below link to assist further:
      https://support.indzara.com/support/tickets/new

      Best wishes.

      Reply

    • Thank you for showing interest in our template and sharing your valuable feedback.

      The same sheet can also be used for 2023 or any year. The yellow colored fields are editable in the template. Hence at the top left of the Team Dashboard and Employee Report you will have the option to change the year.

      Best wishes.

      Reply

  • I love the Employee Leave Tracker, but how can I view different years at one time? Ex. We are a school so I need to be able to see how many days they used that school year not the physical year. I need to be able to view Aug. 2022- July 2023 instead of just Jan.-Dec. 2022. Is this possible?

    Reply

  • Hello. How can I enter two separate leave periods for one employee? Thanks

    Reply

    • Thank you for showing interest in our template.

      You need to enter the same employee name again in a new row and provide a different leave period.

      Best wishes.

      Reply

  • Is there a way to have a calculation to figure out the “allotment” of hours each employee is entitled to? i.e. – year one – year 2 = 5 days
    year three – year five = 10 days
    etc.
    Then have it subtract when vacation time is used?

    Reply

  • Hi guys – great template! I have added a field to track annual leave per employee – is there a formula I could use to pro rata the days from when they started work with us? In other words, if our annual entitlement is 28 days – I’d like to be able to calculate prorated entitlment from their ’employee start date’.

    Thanks! Mike

    Reply

  • Hello Team,

    Good Template, If an employee worked on weekends, what is the formula for monthly Leave Dash board & workdays.

    Reply

    • Thank you for showing interest in our template.

      Currently, the requested features is available in our Leave Manager Premium template where you can apply negative value on a weekend or holiday to count it as a working day or makeup day. Following is the link to the same for quick reference:
      https://indzara.com/product/employee-leave-manager/

      Best wishes.

      Reply

    • Thank you for showing interest in our template.

      Yes, you can multiply each working day with standard working hours (22 * 8 for a month) and then you can apply leaves in hourly basis.

      We take customization project for a fee, please write to us at the below link for estimation:
      https://support.indzara.com/support/tickets/new

      Best wishes.

      Reply

  • I love how detailed this article goes. It’s true that digitizing everything can be beneficial and handy. However, taking advantage of what Microsoft Excel can do is also innovative. You’ll be surprised that there are a lot of things excel can do beyond what you already knew.

    Reply

    • Thank you for sharing your valuable feedback. Yes, there is a lot of opportunity to learn in excel to do much more innovative template. We are always open to ideas and try to develop new templates.

      We also have a premium version of the Leave Tracker template with entitlement setup. Following is the link to the same for quick reference:
      https://indzara.com/product/employee-leave-manager/

      Best wishes.

      Reply

  • Hello I need more fields for more employees. Can you message me? Thank you!

    Reply

    • Thank you for showing interest in our template.

      The excel version of Leave Tracker template is not limited with employee count. You can unprotect the team dashboard using the password indzara and duplicate the formulas present in last row by pressing CTRL+D.

      Best wishes.

      Reply

  • Hi there,
    Thank you for the amazing tool. I’m using it on google sheets but I’m wondering how to do a certain functionality.

    We sometimes work on holidays and want these to be counted as a value of -1 so I changed the unpaid leave type to be over time and a value of -1 but it seems that the holiday overrides everything else and I wanted to change that to have the overtime days as the priority so I don’t have to remove these holdiays for the rest of the team.

    Reply

  • Hello, The last 4-5 days of the month have incorrect days with the corresponding date.
    For instance, january starts on saturday and ends on monday,,,this is correct, but when i go to February, it shows the 27 as Sunday, 28 as Monday, then skips to Saturday,,so i go to march, and it starts on correct day, but it ends with the 28th as a Monday, 29th as Saturday, 30th is Sunday, and 31st is Monday. If i change them in the spreadsheet, for that month, they are copied to next month.
    How can I fix this? So to recap, each month end shows the wrong days of the week.
    Regards,
    Tracey

    Reply

    • I have checked the fresh copy of the template and found that it is showing correctly in our end. Hence I would suggest you to move your data to a fresh copy of the template to resolve the same.

      Best wishes.

      Reply

  • My employees have different weekends. How can i assign different weekend days to each employee?

    Reply

  • Good morning
    A couple of queries, please

    1) I succeeded in changing the colors on the Team Dashboard
    2) However it doesn’t replicate under Employee Report
    3) We are tracking a 6th leave item (Exchange Days)
    – the Employee Report is the only one that has additional space when moving around I seem to have disturbed the formulaes. Hence, I kept it to the 5 categories. Is there a way I can include it without disturbing the formulaes
    4) the Employee Report provides for all employees’ YTD leave taken/consumed/worked. But when I put in a formula to calculate YTD balance, and when you move from employee 1 to 2, that formula moved from employee 1 to 2… but 2 may have different leave entitlement.
    Is there a way you track balances here

    Reply

    • Thank you for using our template.

      Regarding colors,

      We are glad that you succeeded on changing the colors in Team Dashboard but you will have to do the same in Employee Report again, since both have different conditional formatting.

      Regarding 6th leave category,

      Adding additional leave category involves formula level changes. Our premium version of the template will allow you to use 6 leave categories and more. Following is the link to the template for quick reference:
      https://indzara.com/product/employee-leave-manager/

      Regarding YTD leave taken/consumed/worked,

      Currently, our premium version will provide you YTD leave taken and consumed but YTD worked days is not available. You can write to support@indzara.com after purchasing the template to add the same, we take customization project for a fee.

      Best wishes.

      Reply

  • if suppose a employee works over a weekend how do we keep track?

    Reply

    • Thank you for showing interest in our template.

      Currently, you do not have an option to convert the weekend as working day in this template.

      Best wishes.

      Reply

  • What if the employee works in holidays or in weekends? how we can get the data in summary sheets.

    Worked days will increase
    Can i get the separate column like as total comp offs(worked in Hlodays and weekends) fro each employees

    Reply

    • Thank you for showing interest in our template.

      Currently, the requested feature is not available in the template and we take customization projects for additional fee. Please write to support@indzara.com for estimation.

      Best wishes.

      Reply

  • Hello! Love the template. I’ve added a new column to the employee data tab to assign employees to different teams and added a drop down to the team dashboard to filter down to (B7) the team i’m interested in. How would you update the formula under employee name (column B) to return results based on the filter? Or something to that effect. Thanks!

    Reply

  • How can I do this by the hour instead of by the day? We track employees hours.

    Reply

    • Thank you for showing interest in our template.

      Currently, the template is designed to calculate in days, but you can edit all the formulas that are reflecting the days and type *8 at the end of the formula to convert it to hours instead of days. 8 can be anything according to your companies regular working hour’s policy.

      Best wishes.

      Reply

  • How can we have multiple tables for the various holidays in different countries? I work for a global company and easily discern which holiday goes with which employee based on their country all in the same tracking sheet.

    Reply

    • Thank you for showing interest in our template.

      It is possible by adding two or more different holiday table or by adding a column to the holiday table to map the holiday with the country, but it involves some formula changes as well. You will have to modify the calendar formulas to calculate holiday according to employee’s country. We can take it as a customization project for a fee. You can write to support@indzara.com for estimation.

      Best wishes.

      Reply

  • Thank you for the template, it’s very useful.

    Although, I am trying to add “Leave Entitled Days” and “Leave Days remaining” in the Employee Report Sheet but the data remains the same when I change Employee Selection.
    How could I get the Data to change with the Employee?

    Reply

  • Hi,

    I want to calculate the total vacation leaves for the year instead of every month, how i can do that in excel?

    Reply

  • What is the easiest way to create a Team Dashboard sheet for each month of the year?

    Thank you,
    Sherri S. Atwood

    Reply

  • I love your Leave Tracker. The logic and the layouts. How do i purchase a version that it is not limited?

    Reply

    • Thank you for showing interest in our template.

      The premium version of the template is available at the link below:
      https://indzara.com/product/employee-leave-manager/

      The premium version and the free version is only limited with the number of leave types. The free version has 5 leave types with fixed day value. Our premium version of the template has 12 different leave types with dynamic leave value.

      Best wishes.

      Reply

  • I am looking at the 2022 calendar and it has made my first employee in the Team Dashboard on vacation for every day of the year, yet these dates are not entered in the Leave page

    Reply

  • Hi all, just wondering whether the calendar is up to date? It doesnt show 2022 dates correctly and 31st is usually missing. How can I update this?

    Thanks

    Reply

    • Thank you for using our template.

      We are unable to replicate the highlighted issue in our end. Requesting to share your sheet to support@indzara.com to check further.

      Best wishes.

      Reply

  • Hello
    I love it!
    But why isnt there any Year Dashboard over all Person?

    Thanks
    Fabri

    Reply

    • Thank you for sharing your valuable feedback.

      If you are referring to a report to show the total leave taken using each leave type for a year, it is available in our premium version of the template. The same is available at the link below:
      https://indzara.com/product/employee-leave-manager/

      If you are referring to 365/366 columns to display 365/366 days of the year, it is not done since the same cannot be viewed in a single page. But you can still look at one month at a time.

      Best wishes.

      Reply

  • Hello there, I apologize if I am missing a step but … I’ve added the employee’s names to the employee’s tab and used the formatting in the sheet, i’ve added the leave and start dates in the proper formatting and both team dashboard and employee report don’t show anything … a little help here please? Only Employee 1 is shown and I have deleted him

    Reply

      • I shall say my issue was fixed by manually making the tabs re-calculate, they just aren’t updating automatically, but that’s not an issue to me.

        I’d love to be able to make the END DATE of the Employee report, December 31st of the current year, so that I can look at all the future vacations altogether. How can i do that if you don’t mind me asking?

        Reply

  • Hello Indzara,

    I have a challenge with just 1 employee. His information keeps coming out has wrong and I have tried changing the row, I place the employee, I have tried changing the name. But still to no avail. Kindly advise on what should be done

    Reply

  • I need to add remaining leave days for previous years to calander as the previous HR manager did not keep track of leave taken- I now have to make due with leave currently and manage it from hereon – need to show employees exactly how many leave they have left as per there employement contract

    Reply

    • Thank you for showing interest in our template.

      Currently, the leave entitlement setup is available in our Employee Leave Manager template and you can use the Adjustment tab to allocate employee specific leave entitlement for each leave type. Following is the link to the template:
      https://indzara.com/product/employee-leave-manager/

      Best wishes.

      Reply

  • We have a restaurant establishment, how can we select “weekends” for different employees? For example, those who work in the office have Saturdays and Sundays off, but everywhere else’s weekend is Sunday Monday because those are the days the restaurant is closed.

    Please help!

    Reply

  • Hai,
    if a person is taking vacation for 15 days which includes weekends too, i want to add weekends also in the vacation count. Kindly let me know how to do it.

    Reply

    • Thank you for showing interest in our template.

      Currently the formula verifies the Weekend before validating the planned vacation days. So you will have to swap the if condition to check the weekend below/after validating the planned vacation.

      We take customization project for additional fee. Requesting to write to support@indzara.com for estimation.

      Best wishes.

      Reply

  • How can I filter to show everyone who was absent on a certain day? Also, is there any way to add a slicer to make filtering easier?

    Reply

    • You can unprotect the team dashboard using password indzara and select cells B7 to AG7 and press CTRL+SHIFT+L to apply filter.

      Regarding slicer,

      You can add a row between 7 and 8 and select cells B8 to AG38 and press CTRL+t to convert the selected range to table. Now you can use table slicers.

      Simplest way to solve your requirement,

      Have a place in Team dashboard to enter the date you want to filter and modify the Employee List formula to show only the employees who took leave on that date. This can be take as a customization project for additional fee and you can write to support@indzara.com to get an estimation.

      Best wishes.

      Reply

  • Hello, thank you for providing with a great template to keep a track of all employee vacations. I do have a question in the Employee Report tab – somehow template is only showing data for up to rows 33 on the Employees tab – any person added down from row B34 onwards is not visible on the Employee Report tab. Can you help out with that.

    Thank you,

    Reply

    • You are welcome.

      I believe, you have entered the employee data outside the employee table, due to which you are unable to select the employee in employee report. In team dashboard, you will have to duplicate the formulas from the last row to more empty rows to view more more employees in the dashboard. If you are still facing the issue, requesting to share the sheet to support@indzara.com to check further.

      Best wishes.

      Reply

  • If my employee has some balance leave that he/she is not able to clear and would like to carry it forward to the next year, how do we show it in the excel template? as different employees may have different amount of leave to carry forward

    Reply

    • Thank you for showing interest in our template.

      If you have fixed leave like 15 days for a year, then the requested feature is available in our Employe Leave Manager template.

      If you have prorated leave accrual like 2 days/month with a max year balance according to tenure or fixed, requesting to check our PTO manager template.

      Best wishes.

      Reply

  • hi, is it possible to add the staff total annual leave entitlement per year? and will automatically be deducted (to see their balance) in the sheet? same as in other types of leave. Thank you

    Reply

  • REQUEST TO SHOW EMPLOYEE REPORT AS A FINANCIAL YEARWISE (APRIL TO MARCH)

    Reply

  • Thank you for such a wonderful template. How can I insert a column in the team dashboard after the employee name column namely designation? Is this sheet protected? How can I unprotect it?

    Reply

    • You are welcome.

      You can unprotect the sheet using the password indzara.

      Regarding adding another column, you can add another column and copy paste the similar formula to get the employee name and make slight modification to get the designation.

      Best wishes.

      Reply

  • Hi, Love this tracker but have a question. If we want to update it every year, do we just change the ‘year’ displayed in the Team Dashboard & Employee Report Tabs? Does it automatically update the information as appropriate?

    Reply

    • Thank you for sharing your valuable feedback.

      Yes, you will have to change the year manually in team dashboard and employee dashboard on the cells highlighted in Yellow colour.

      Best wishes.

      Reply

      • Thank you! One more question. How can we add more Holidays in the ‘Settings’ tab?

        Reply

  • It is such a great and helpful template! I use it all the time in all of my projects.
    Especially, I love the team dashboard for monthly reports to my customers – this template makes monthly staff reporting quick, efficient and self-explanatory.
    Even more, upon my request, Dennis from Indzara’s team introduced a few amendments in the template to meet my particular needs, specifically: indicate certain weekend days as workdays which took this template to absolute perfection!

    Reply

  • Hello! Thank you for the wonderful spreadsheet!

    I am having a problem with the “TEAM DASHBOARD.” Once I changed the year, it no longer shows the data that I have inputted on the “LEAVE” tab on the Team Dashboard. Is there a reason for this?

    Thanks,
    Erica

    Reply

    • Thank you for sharing your valuable feedback

      I am unable to replicate the issue, hence requesting to share your sheet to support@indzara.com to check further.

      Best wishes.

      Reply

  • Hello! Thank you so much for providing this template. I added a new column next to employee termination date and was wondering if it is possible to display that data on the employee report section. I am also struggling to add more rows to the employee list even after following your instructions. Any help you can provide would be greatly appreciated. Thank you again!

    Reply

    • You are welcome.

      Requesting to share your sheet along with some screenshot highlighting your requirement to support@indzara.com to check further.

      Best wishes.

      Reply

  • Hello,

    This is really a good template!
    However I would like to know if there is a possibility for each employee to have a different WEEKEND day?
    An if there is a possibility to put in freelancers that are working just few time a month?

    This is probably possible if in some way we can have a SETTINGS sheet for each employee.

    Reply

    • Thank you for sharing your valuable feedback.

      Regarding Weekend,

      Yes, it is possible by adding the weekend selection in Employees tab.

      Regarding freelancers,

      We can add a new tab in Employee tab to select Free Lancer or Regular employee. Then we can collect the working days from the Leave tab. This will be a major customization.

      We take customization project for additional fee. Requesting to share this requirement to support@indzara.com for estimation.

      Best wishes.

      Reply

  • Hi there,
    I really like your spreadsheet, however, I need to carry over the vacation leave from previous year, is there a way to do it?
    Thanks in advance for your help.

    Reply

  • Thank you for this template. I have staff that is paid hourly and may only use 1 hour of their vacation time – how could I adjust this template to track that? Thanks

    Reply

  • Hey. the template is amazing but I need to add more employees to the team dashboard. could you please share the password so that I can start working on that?

    Reply

    • Thank you for using our template and sharing your valuable feedback.

      The password to unprotect the sheet is indzara and the same will be available in the Info tab for future reference.

      Best wishes.

      Reply

  • I found your blog and I like your information about the employee leave vacation tracker and the tips you have shared are informational. I liked it and it is wonderful to know about so many things that are useful for me. Actually, I am also running a tracking site and Know days I am working on employee vacation tracker your blog is very helpful for me Thanks a lot for this blog!!

    Reply

    • Thank you for using our template.

      You can directly edit the existing dates or enter new dates from Column H row 15 in Settings tab. If you are having complications on processing the same, requesting to share your sheet with some screenshots highlighting your concern to support@indzara.com.

      Best wishes.

      Reply

    • Thank you for using our template.

      You can enter unlimited leaves one below another repeating employee names with different dates. If you face any complications, kindly share your sheet to support@indzara.com to fix the same.

      Best wishes.

      Reply

  • We absolutely love your employee tracker. This has been a amazing tool for our team to use. My question is how can I add a 6th type of time off (bereavement)?

    Thanks in advance for your help!

    Reply

  • I am so happy I found your blog and I absolutely love your information about employee leave vacation tracker and the tips you have shared are awesome. I liked and it is wonderful to know about so many things that are useful for all of us! Thanks a lot for this amazing blog!!

    Reply

  • Love your excel spreadsheets. However, what if I have multiple employees with different vacation and PTO days. Example: Employee 1 has 14 days of vacation and 6 PTO days a year. Employee 2 has 7 days vacation and 7 PTO days. I can only see that your input on takes one total of days for all employees.

    Reply

    • Thank you for showing interest in our template.

      The employee entitlement setup is not available in this template. However the same is available in Employee Leave Manager template. In Employee Leave Manager template, if each employee has different entitlement setup, you can set the default entitlement for each leave type as 0 and apply it as adjustment for each employee for each leave type. Following is the link to the product:
      https://indzara.com/product/employee-leave-manager/

      Best wishes.

      Reply

  • Thank you very much for sharing these ideas. I really appreciate your efforts for creating this exceptionally well content. I was looking for such content about employee leave vacation tracke, you have really helped me with the same… great post!!

    Reply

    • You are welcome.

      Thank you for using our template and sharing your valuable feedback.

      Best wishes.

      Reply

  • You’ve done an excellent job with both building the template and explaining how it works, how to modify it, even change colors. And for free? In these days, that’s unheard of.

    I have a different form that I’m working on (and I don’t have the skills you do). Its for tracking receiving and using COVID related inventory (masks, hand sanitizers, disinfectant, etc for multiple locations that I’m responsible for. I have something in the works but would love to collaborate with you or see if you’d be interested in redoing it for a reasonable fee.
    Regardless, best of luck. You’re very good at what you do!
    Michael

    Reply

    • Thank you for using our template.

      You can change the year in cell B3 in Team dashboard and in cell B4 in Employee dashboard.

      Best wishes.

      Reply

  • I just downloaded this tracker and have entered the respective data. However, the Team Dashboard and Employee Report are not updating with the red box (for a personal day) that SHOULD populate when I entered the start/end leave data on the Leave spreadsheet. What am I doing wrong?

    Reply

  • I purchased the course through Udemy, it was more than helpful, but how I can add departments for my employee and show the annual report per department?

    Reply

  • The tracker is amazing and had proven to be very helpful. I am trying to add 2021 to the template. How do I do this?

    Reply

  • Hi
    My company gives each employee an extra days holiday after working for us for 5 years up to a max of 10 years, each employee started work in different years so do not all have the same entitlement how do I include this in your template?
    Many thanks.

    Reply

    • Thank you for showing interest in our template.

      This template does not support leave entitlement setup.

      However I would like to inform you that, following template does support leave entitlement.
      https://indzara.com/product/employee-leave-manager/

      The additional leave or employee specific varied leave can be entered as adjustments in the above mentioned template.
      Best Wishes.

      Reply

  • Wow awesome template! I have worked on it a few hours and I am very impressed. Thanks for sharing this.
    However, I noticed that the “holidays” and “weekends” are displayed in the dashboard with priorities over “vacations” or other “leave type”. They will show up in their color over any other type of leaves. To help me with my planning, I’d like to see if the vacation an employee is planning falls on a Holiday (example statutory holidays set by union). Anyway of making them show over?

    Reply

    • Thank you for using our template and sharing your valuable feedback.
      To highlight the leave above the Week ends and Holidays, you will have move the index formula prior to wknd and H. Requesting to contact suuport@indzara.com for more details.

      Best wishes.

      Reply

  • I absolutely love this tracker. It has helped out so much for my company. I am confused on how to add additional years though. Currently I am trying to add 2021 to the template. Can you please post the steps as to how to go about this?? I would appreciate it so much. Thank you!!

    Reply

    • Thank you for sharing your valuable feedback. You can just change the year in Employee and Team tracker or if you want to show two years in employee report, requesting to contact support@indzara.com.
      Best wishes.

      Reply

  • My department has 3 types of teams which refer to their days off. Team A off Monday, Tuesday, team B Thursday, Friday and team C Saturday, Sunday. Then the teams will rotate every 3 months. Is it possible to set certain employees with certain days off?

    Reply

    • Sorry, currently the requested rotational week off feature is not available in our templates, but you can have Week Off as a leave type to solve your requirement but it requires additional data entry.
      Best wishes.

      Reply

  • Our business is open 7 days a week and employees work different shifts. For example, employee A may work Sunday through Thursday and employee B may work Friday through Tuesday. If I designate Saturday and Sunday or any other two-day combination as ‘weekend’ it does not calculate the correct number of days worked when a shift straddles those two days. Is there a way around this? We also carry unused vacation days forward.

    Reply

    • Thank you for using our template.

      You will get a response from our support team shortly.

      Best wishes.

      Reply

  • Amazing leave tracker! Thank you so much for sharing this template. Is there a way to calculate number of leaves per day and show it on the monthly view (on top of the date for each day of the month)?

    Reply

  • I love it!!! Really I just love it!!! It’s very detailed and organized! You have done great job!
    How can I extend it? I would like to keep that template for the next years….

    Reply

    • Thank you for sharing your valuable feedback.
      There is no limits on years or number of leave entry. You can add any number of leave entry as per your system’s capacity to load the file and have sheet utilized for any number of years.
      Best wishes.

      Reply

      • Hello again! I would like to ask you how can I enter the next year (2021)? I have added in the first sheet the holidays of the next year, but I have no clue how to proceed with the rest of the sheets, and I mean of course the “Team Dashboard” sheet and the “Employee Report”
        Thank you in advance!!!

        Reply

  • Absolutely impressed by your template, its very detailed, and well organized , although it would be nice to see opening balance of leaves, that shows the remaining for each individual, As currently there is no such facility.
    But having said that , thanks a lot for this lovely format, especially customizing options are not at all complicated.
    But please help with regards to leave opening balance and remaining days that calculate for each individual as its different for everyone., that would be an icing on the cake..

    Reply

  • how to override maternity leaves over weekends, as my company has some employees taking a maternity leave , but weekends are included in them , and not excluded, so i want to apply Maternity leave format on weekends also to calculate exact vacation dates

    Reply

    • Thank you for using our template but the requested feature is currently not available. However we are taking customization projects for additional fee, hence requesting to contact support@indzara.com to get an estimate.
      Best wishes.

      Reply

  • Hi,

    I downloaded the leave vacation tracker and its not calculating the vacations properly for some months.

    Reply

  • Hi, when i enter a selection of leave type for, example May, this selection remains for other months also. How do I ensure the selection is dynamic?

    Reply

    • Hi,

      Thank you for reaching out to us.

      Sorry! we are unable to understand the exact requirement. Hence, requesting to share your requirement with sample data in excel file and screenshots to support@indzara.com to further check on your concern.

      Best wishes.

      Reply

  • Hi I really like the Employee Vacation Tracker but the only feature missing for our office is annual leave allowed for the year and what is rolled over from one year to the next. Also, we have part time workers as well and I would like a feature which shows their annual leave allocation and automatically deducts from the allocated leave and roll over throughout the year. Is this possible?

    Reply

  • This template is great.
    I am wondering if it is possible to add a column with the employee’s entitled vacation and a second column to calculate the balance of their available vacation.(Unbooked) on the dashboard and employee section. Instead of the total leave and worked days I would like it to have vacation entitlement and available vacation balance displayed there.
    I like the fact if I re-arrange the employees the booked dates move with their names.

    Reply

  • I want to modify each employee individual report to include the total time they are entitled to in cell AQ and track via another sheet1 but it is keeping the same formula for all employees on the drop down even after I save. For example one employee has 7 days total and another 6 but it won’t let me input individual formulas for each person. Can you please assist? Thank you

    Reply

  • Hi there,

    I found this template very useful. I am wondering instead of tracking days of time off, if there is a way to modify this sheet so that specific hours are tracked? For instance, our company allows staff work OT so specific hours need to be tracked by inputting OT 3 hrs and at a later date, when it’s being used, remove it by using the negative number from the leave tab (i.e. Time in Lieu 3) which than is reflected on the dashboard and changes the remaining balance to 0.
    If there is a course for this, I would love to take one!

    Reply

  • Is there a way i can allow each person to have a different amount of holiday, someone who started half way through the year may only have 11 days holiday to use, where as someone who has worked from the beginning of the year may have 21?

    When i change it for 1, it changes for everyone?

    Thanks

    Reply

    • Thanks for your message.

      We will recommend you to review our Small Business – Paid Time Off (PTO) Manager – Excel Template at https://indzara.com/product/small-business-paid-time-off-manager/. This template has the following features

      Manage Paid Time off (PTO) for multiple employees in your organization/company, in one file

      Two types of paid time off can be managed. Example: Vacation and Sick days

      Automatically calculates PTO balances for today and any future date

      PTO calendar to view leave/time-off across employees and plan monthly availability

      Automated Employee PTO report that is print-ready or can be exported to PDF

      Several options available to cover most common business PTO policy scenarios

      Best wishes

      Reply

  • This works really well, except how do i edit the formula so that it does not deduct sickness and home working from your leave? If an employee gets 22 days holiday, I do not want the formula deducting leave when they work from home as this template seems to do that? I simply only want it to look at certain codes and deduct those eg vacation and half days.

    Reply

  • Good Morning,

    Template was working fantastic and is the solution i was looking for. Unfortunately its not dragging certain dates through. Any help would be great.

    Reply

    • Hello

      Please ensure that the employee joining date is before the date leave is availed. Also, make sure dates are entered in the correct format. If you still face any issue, please email the file along with the list of issues to contact@indzara.com.

      Best wishes

      Reply

  • Dear Sirs,

    Any Application of Leave Tracker Excel Free Templates linked to Approval authorised by HOD (Head Of Departments) before Leave is updated in the system?

    Regards,
    Janice

    Reply

    • Thanks for using our template.

      This feature is not available in the present version, we will try to add this feature, if feasible in the future releases.

      Best wishes

      Reply

  • Hi am getting this error on Enter Leave Data sheet.
    There is a ! sign on employee name and giving error the value in this cell is invalid or missing. Click on display type information for specific details. No information filled up in employees sheet is on the drop down on Enter Leave Data sheet.

    Reply

  • Good day.
    Is it possible to keep track of employee sick leave over a 36-month cycle from the date they were employed?
    Annual leave is easy as it is over 1 calendar year. However sick leave is over a 3-year cycle?
    Is this possible?

    Thanks.

    Reply

  • Is it possible to adapt this template for an academic year opposed to a calendar year? ie. Sept – July

    Reply

  • Hi
    I would like the Team Dashboard tab to display two months of leave at a time. Is this possible?

    Reply

    • Thanks for using our template.

      This template is designed to show the data for a month on the dashboard. We might have your recommended feature in the future releases.

      Best wishes

      Reply

  • Hello, I find the tool very useful, but in our office we use only googlesheet, is it possible to convert this excel ?

    Reply

  • Hello. When applying Vacation, the template does not fill in the dates as designed for an employee during November and December. If I try to simply use the “fill” option to indicate those dates, August, November, and December all fill. I am trying to have this adopted by our global support team but cannot have that done if there are errors. Your help with this is appreciated.

    Reply

    • Hello

      A day marked as the weekend will not be calculated as a leave.

      Thanks

      Reply

  • 1. How can I add fields for duty station if my employees are in various locations and have it in a way it can be filtered to view a preferred location.
    2. How can I factor in the employee leave balances and monthly accruals? I would wish to see the balances after deduction for leave taken especially for Annual leave.

    Reply

  • how do i add more than one type of leave for one employee? so that it tracks for the year

    Reply

  • I need to add up to 7 different types of day, Could I do that, and if so how?

    Reply

  • Hello, so I added PTO day for the month of May and it reflected to and added PTO for all months in the year. I want to add PTO without it affecting any of otherdays

    Reply

    • Hello

      This template is designed to track the leaves availed by an employee. Please clarify more with examples and share your file along with the list of issues to contact@indzara.com.

      Best wishes

      Reply

  • I have 3 different locations and I would like to see them together but at the same time have a differentiation in between them is that possible?

    Reply

    • Thanks for your message.

      This template considers that weekly off and holidays are same for all employees. You can make a note for the location, however, the weekly off and holidays will be applicable to all employees.

      Best wishes

      Reply

  • we have a leave policy of quarterly basis, can you please let me know. How can we adapt this sheet to our requirement?

    Reply

    • Hello

      This template can be used for a calendar year. So you can use this template for a quarter as well. Could your please specify with more details and examples. You may write to us at contact@indzara.com.

      Thanks

      Reply

  • Hi, thank you for sharing this wonderful excel spreadsheet! 🙂

    Question: What if we are to work in the weekends and that we would like that to count, how do we overwrite the formula to count the weekends, when there is work?

    For example: If i were to register work travel for Employee 1 from Friday 29 March 2019 – Tuesday 02 April 2019, I would like to count the work travel days as 5 days (including Saturday & Sunday), how would i do this?

    This kind of work is very sporadic. It doesn’t happen very often but it does when sometimes when there is work travel in the wekend, we count it as such.

    Reply

    • This would mean that there will only be a limited number of weekends where work travel is required. Let’s say for this example, Employee 1 has this specific weekend work travel in March.

      Reply

      • Thanks for using our template.

        The weekend defined is applicable to all employees of the organization. Since this is a one off case, you can add a note or comment for that data. Else, you can define weekends for each employee in the leaves tab.

        Best wishes

        Reply

  • IndZara, your templates and Vedios are amazing, simple way of explanation, and i would say its awesome. Leave tracker is awesome excel sheet. i was broken when i see the there was no weekend for me as i work in shifts, i saw one of your comments to include the rest off days in the leave sheet, thats a wonderful idea. thank you very much. My wishes and prayers are with you. God bless you.

    Reply

    • One More thing i want to ask you is that, in my roster i have 8 employees, and we work in 3 shift rotation, ex: Morning(M1), Afternoon(A1), Night(N1), can this be shown in the Team Dashboard sheet, the entire purpose would be solved for me. also if there are more shift codes, provision to add pattern and Code. i would wait for your reply or email. thank you

      Reply

      • Thanks for your advice.

        We will try to incorporate this feature in future releases.

        Best wishes

        Reply

    • Thanks for using our template and sharing positive feedback.

      Weekly offs are applicable to all the employees. In this case, you can allocate a weekly off to each employee separately.

      Best wishes

      Reply

  • HI,
    This leave calculator workbook is brilliant, just a thought what if we don’t apply one standard weekend to all staff, for instant operation field weekends do varies from person to person, I’m wondering if your workbook can resolve this matter in some fashion.
    thanks

    Reply

    • Thanks for using our template and sharing a positive experience.

      The weekend defined is applicable to all the employees. Else, you can allocate weekly off to each employee in the leaves sheet.

      Best wishes

      Reply

  • I was not able to download the templates because my virus protector stated that the template was unsafe. Please advise!

    Reply

  • This is absolutely fabulous!! Is there a “simple” way to see an academic year from 7/1/2020 to 6/30/2021 instead of the traditional annual jan to dec??

    Reply

      • Ahh, interesting. I will check it out. Would the premium version allow me to change the priority of “holidays” and weekends.” Our use is a bit unique, folks get a couple of holidays off but if they take a vacation week block, those days count as vacation days and not a holidays. Does that make sense?

        Reply

        • Thanks for your message.

          The defined weekends will not be calculated in block vacations. If an employee is taking leave from one Monday to the next Monday (assuming Sat and Sun are weekends), it will count as 6 leave days and not 8. Sat and Sun will not be counted as leave days against the leave allowed for the employee.

          Best wishes

          Reply

  • I think this is an amazing leave tracker tool which works amazingly for my exempt employees with using days or half day increments. I would like to know how to change this value to one that is strictly hourly. For example an employee uses 3 hours of FMLA leave time deducting from their entitlement of 480 hours. If you could help with that it would be wonderful.

    Reply

  • Hi there, this template is exactly what I need. However, when I enter data under LEAVE tab, the dashboard doesn’t update and show the leave. Do you have any ideas why this would be happening?

    Thanks,
    Leah

    Reply

    • Thanks for using our template and sharing your positive feedback.

      At times a broken link or a deleted formula may be the reason. We will request you to download a fresh file and check if it works. In case the issue persists, please share your file along with the list of issues to contact@indzara.com.

      Best wishes

      Reply

  • I got a lot of information from this post. Thank you for the fantastic blog. Leave Management System is another precious tool that helps the organisation specially the HRs to Manage the system of leaves and makes it easy to refer later by managers. I would like to prefer https://captureleave.com for Leave Management System which work amazingly.

    Reply

  • HI. your template is very useful. but what if i have more that 5 leaves?

    Reply

  • Wonderful Tracker , Very helpful… I really love the individual Employee Report & Employee Termination data. Thank you so much for sharing this Template.

    I am additionally looking for one more option regarding Holidays. Some of the employees are located in other states and they have different Holiday list. How can I apply other state holiday to some specific employee appropriately?

    Idea: If I could select the Location of the Employee in “Employee” Sheet and Mention State Holidays it should populate values accordingly…

    Thanks
    Ganesh

    Reply

    • Thanks for using our template.

      The holidays and weekly offs are applicable to all employees.

      We have taken note of your recommendation and will try to implement it in the next release.

      Best wishes

      Reply

  • hi there. I really love your tracker. It is very helpful and informative. We can definitely use this. However, I have things to add but I don’t know how. Below are my queries:

    1. In our company, we count weekend as number of leaves too. Say for example your leave starts from Monday and ends Monday next week. Since some days falls on a weekend, this too should be counted. Can you help me do that?
    2. I would like to add a department Column in the Employee Tab. And add the same in Team Dashboard tab. This way, The team can be able to view the leaves Department wise.

    Thank you.

    Looking forward to your feedback.

    Reply

    • Thank you.

      1. In the formulas used in Team Dashboard and Employee Report, we give higher priority to Weekend over leave. We need to reverse the order in the formula to count weekends as also leave if they are within a leave range of dates. if you need assistance, please email file to support@indzara.com
      2. Department column is available in the Leave Manager template in Team Dashboard and Team Balance report. https://indzara.com/product/employee-leave-manager/
      Best wishes.

      Reply

  • I have entered the dates of all holidays for our company as directed. But it is not showing on the team dashboard as highlighted. There is no indication of the holidays at all.

    I went through your step by step instructions but it will not show as highlighted.

    You assistance is appreciated.

    Reply

  • Thank you for the tracker. it is really beneficial on my part. I just have one issue I wanted to address, and i’ve been stuck there for awhile now. For example, employee 1 has paid annual leave from July 1 to 20 which would make it a total of 20 annual leave. however on employee report tab, it will only count a total of 13 on annual leave as it doesn’t include counting the days that falls on weekends and holidays for that certain period. i needed the annual leave counted as ease which is 20 days. Is there anything that can be done?

    Reply

    • Thanks for using our template and sharing wonderful feedback.

      Any weekend or a holiday that is defined in the settings will not be part of the vacation. In this case, in a span of 20 days, there will be two weekends. So if each employee gets a day off in a week, then the actual vacation availed will be 2 days less.

      Best wishes

      Reply

      • in where i leave however, annual leave for employee is 30 days and weekends and holidays are counted if the the leave falls on it. i just needed it to show 30 days in the total count of annual leave

        Reply

        • Hi Lowella, I have the same issue to address. Please let me know if there is a chance you have yours working. Thank you.

          Reply

          • In the formulas used in Team Dashboard and Employee Report, we give higher priority to Weekend over leave. We need to reverse the order in the formula to count weekends as also leave if they are within a leave range of dates. if you need assistance, please email file to support@indzara.com
            Best wishes.

    • Please email screenshots of any error messages to support@indzara.com
      I can assure you that hundreds of thousands of users have used the files without any issues.
      Please provide details of your browser and operating system along with screenshots.
      Best wishes.

      Reply

  • What is the formula for accumulation of holidays year on year? I can add this column right

    Reply

  • I love this tracker! Is there a way to have the tracker also count how much leave an employee has left each month? And also notify you when there is no more leave available? Example: Employee 1 starts with 120 hours for the year. I would like to see how much leave Employee 1 has each month until there’s none left. Like a countdown.

    Thanks for your time and doing great work!

    Reply

  • Is there a simple way to make this spreadsheet calculate by the hour instead of by the day? Most of our employees are paid by the hour and can use anywhere from 0.25 to 8 hours of personal time per day. Any help you can offer would be greatly appreciated. Thanks!

    Reply

    • The template is currently designed only to track in terms of days. Is it possible to put the hours as fraction of days? if the standard day is 8 hours of work, then 2 hours of personal time would be entered as 0.25 day?
      Please let me know.
      Best wishes.

      Reply

  • This is incredible. and your video and text instructions are equally clear and easy to follow. But I have one issue: How can I enter multiple leave types for the same employee…. it seems that the sheet “LEAVES” only allows 1 set of data. For example employee ROBERT was sick on 17th Jan. He will also be on vacation 22 – 29 Jan… but I have already used the space for sick leave which is over written when I then enter vacation dates. Thanks, Kim

    Reply

    • Thanks for sharing your positive experience.

      Any leaves that you enter has a start and end date. Also, any kind of leave availed will be added into a separate row. For instance, sick leave will have the same start date and end date. However, vacation will have separate dates. In case you face any issues, please email your file along with the list of issues to contact@indzara.com

      Best wishes

      Reply

  • Great spreadsheet! I do have a question. I need a cumulative calculation for each year. So on the ‘TEAM DASHBOARD’ tab were it says MONTHLY SUMMARY I would need an annual summary. How is that possible?

    Reply

    • Thanks for your suggestion.

      This feature is not available in the template yet. We will try to incorporate it in the future release.

      Best wishes

      Reply

  • Hi!

    Thank you for sharing such a valuable template.

    Just one question please: Where can we enter the number of leaves entitled to employees at the beginning of the year? For e.g. All our employees are entitled to 24 days starting 1 January. To that, we add the unused leaves from the previous year. Let’s say Employee 1 has 24+2, how do I manage this? I tried to copy +paste your formula =IF(B8=””,””,(EOMONTH($C$7,0)-$C$7+1)-(COUNTIF($C8:$AG8,”NE”)+COUNTIF($C8:$AG8,”H”)+COUNTIF($C8:$AG8,”WKND”))-AN8), but it gives 25 days.

    Please advise.

    Thank you!

    Reply

    • You are welcome.
      This template does not calculate balances based on entitlement. New formulas in new columns have to be written to add that feature.
      Please try the Leave Manager template https://indzara.com/product/employee-leave-manager/ which allows leave entitlement and calculates balance.
      Please let us know if any questions.
      Best wishes.

      Reply

  • Hi there, is there any way that I can up the 5 types of leave ? We need about 11 types.

    Also this spreadsheet is just what I needed to get the company’s leave records up to date!

    Regards
    Salome

    Reply

  • Thanks so much Team Indzara for sharing us the detail video and template.

    This is really helpful for the HR & Project Manager and really saved my time for creating a new sheet from scratch.

    Looking forward to more and more Project management relevant template.

    Cheers,

    Reply

    • Thanks for your message.

      You need to assign a weekly off for each employee in the leaves tab.

      Best wishes

      Reply

  • Hi,
    If employee working at weekend or public holiday, how to add back leave?
    Thank you.

    Reply

    • Thanks for using our template.

      This template is designed to handle fixed weekly offs. In case some employees work on a weekend, you need to assign weekly offs to all the employees separately.

      Best wishes

      Reply

  • Hi,

    Thank you so much for this sheet! It is a life/time saver. But how do I change it from 2016, to reflect 2020?

    Reply

    • Thanks for using our template.

      You can delete the data and fill your own data, it will reflect on different tabs. You may note that this template is designed for a calendar year only.

      Best wishes

      Reply

  • Hi Good day!

    I liked the template but I have a question on the plotted leaves. Is there any way to just retain the plotted leaves from previous months on the Dashboard Tab even if you delete them in the Leave Tab? I just want the Leave Tab to be just current but I don’t to compromise the data from previous months.

    Thank you very much!

    Reply

    • Thanks for using our template.

      The data on the dashboard is colled from the leaves table. Hence, if you delete the historical data the dashboard will not show the leaves availed in the previous months.

      Best wishes

      Reply

  • I am unable to download the sample files to try. My computer said they are unsafe to download! What can I do? >_<

    Reply

    • Thanks for your interest in our template.

      Please be assured that all our templates are safe to download and use.

      We have emailed a copy of the Free Leave Tracker & Vacation Tracker Excel Template 2019 at your email if mentioned above.

      Best wishes

      Reply

      • Hi there,
        First, thanks for your reply. However, I did not seem to have received your email and sample template file. Do you mind to re-send? Sorry for the trouble.
        Best wishes,
        Kris

        Reply

        • Hello

          We understand that you are using the above template now. However, we would like to know the reason behind the error messages.
          Therefore, please share the Excel version, Windows version and a screenshot of the error.

          Best wishes

          Reply

  • All my fields show to be password protected so I cannot enter information in the days off fields. How do I obtain the password?

    Reply

  • How to have two different list of holidays. Like India holiday and US holiday and both should be separated with different colors

    Reply

    • Thanks for using our template.

      This template takes holidays as defined in the settings. Having two different holiday sets will not be possible on this template.

      Best wishes

      Reply

  • Many thanks for the template. what if the employee has more than one vacation per year. e.g. one long and two short leaves. How can we add it to the sheet?

    Reply

    • Thanks for using our template.
      All the leaves needs to be entered in the leaves sheet with start date, end date and type of the leave availed.

      Best wishes

      Reply

  • Hi all,

    Our company doesn’t have a Christmas and we work in December, How Can I remove December Holiday and count it as working days ?

    Really appreciate your effort in this template

    Reply

  • Hi,
    Loving the tracker so far and it’s proving very useful so thank you. My one query is if I want to leave a comment tab against somebody’s leave on the team dashboard screen (where they are, contact details etc) the comment is then carried over to the next month and is visible even though there is no leave allocated for that month. Is there a way to lock any comments specific to that month only and not have them carry over?
    Any help is greatly appreciated.

    Kind regards,

    Simon

    Reply

    • Thanks. Glad to hear that you like it.
      I am not fully understanding the part on comment carried over even when there is no leave for that month.
      Based on what I understand, you could create a separate table of EMPLOYEE, COMMENT columns. Then, add a new column of formulas in Dashboard which basically looks up the COMMENT for each employee and displays in dashboard regardless of Leave.
      Best wishes.

      Reply

  • How do I change this calendar on the basis of the financial year? My company’s financial year starting from 1-April to 31-March. Any suggestions, please.

    Reply

  • Hi Team,

    How do I manage carry forward leaves from previous years in this template. Otherwise its a great template and very easy to use so Thank you for that 🙂

    Best regards

    Reply

    • Thanks Reeta. This template does not calculate Leave balances and hence there is no carry forward option.
      In the Leave Manager template https://indzara.com/product/employee-leave-manager/, you can set Leave Entitlement (Quota) and then calculate balances as employee uses leave. There is an adjustment setting where you can add or decrease entitlement for each employee at the beginning of the reporting period (new year as example).
      Please review and let us know if any questions.
      Best wishes.

      Reply

  • 1. My company working half-day on alternate Saturday on each month, how can I set up for this configuration?
    (E.g: Working on 2nd & 4th week of Saturday only)
    2. How can I add additional leave type?

    Thanks!

    Reply

    • Thanks for using our template.

      In this case, you have to mark a half-day or a full day off for each employee in the leaves tab.

      Best wishes

      Reply

  • Is there a way to add in hours worked? We need to calculate the hours per day worked and track that as well. Thank you!

    Reply

    • Thanks for using our template.

      This template is designed to track leaves and not working hours.

      Best wishes

      Reply

  • Hi Sir,
    we have a small school around 40 employees. I am getting a problem in year i.e Our Academic Year Starts from June to May. So i am not able get Employee Report from June 2019 to May 2020. Please help us

    Reply

  • Our company will be giving a half day for Christmas Eve and New Years Eve. How can I have the calendar track these days as half days for employees that will be taking PTO those days besides entering that day as a half day for the employees? Is there a way to make a formula for just those days in the holidays list to state that day is a half day?

    Reply

    • The template does not directly provide an option to handle this scenario.
      Please try creating a leave type (Company Half Day) and assign a value of 0.5. Then, we have to enter all employees as taking leave of that leave type on those 2 days. It is entering a lot of data (copy/pasting).
      Please let me know if this helps.
      Best wishes.

      Reply

  • Hello, your work is commendable and user friendly as well. I do have one question, can we summarize by month and year the employee who applied for leaves either vacation, sick leave, halfday. Thanks.

    Reply

  • Hello. I would like to add a field in employees to denote their department, so I can sort by not only employee but also department (to see coverage) how would I go about doing this?

    Reply

  • Would be great if the Team Dashboard could be displayed for a period with the option to choose the “from date” and the “to date”. Background: We need to plan and roster people over the Chrismas and New Year holiday period. It would be great to have a view of the Team Dashboard from mid-December to mid-January. This would allow us to get a full view of absence and on-site for a critical period in our business. Having to choose Year and Month to get the different views does the trick, but it is cumbersome. Thoughts?

    Reply

  • Hello, could you please tell me how to take the text out of the colour. Some have text and colour but I would like it all to be just colour.

    Thank you
    Julie

    Reply

    • Thanks for using our template.

      Please share more details like which fields you want to be modified.

      Best wishes

      Reply

  • Hi. Many thanks for such an ingenious creation. I only have one challenge, supposing an employee takes more than one leave types in the same month, how do I update that?

    For-instance Employee X is on sick leave from 14-16/10/2019 and then takes Emergency Leave from 21-22/10/2019, how do I capture that, since the template provides for only one entry.

    Thanks.

    Reply

    • Thanks for using our template.

      In this case, in the leaves section, you will mention 14-16th as sick leave and 21-22 as emergency leave.

      Best wishes

      Reply

  • Hi,
    Thank you for the great job…

    The Template works in a way that calculates the working days while the employee is in annual leave etc..
    How can I change the calculation method to “Calendar Day” for the all leaves except the official holidays?

    Thanks and Regards,

    Reply

    • Thanks for sharing your positive experience.

      Any leave defined as a weekly off or a holiday will not be calculated on the annual holiday.

      Suppose, you have a working week between Monday to Friday, then an employee availing his annual leave of say 7 days will spread off to the next week.

      Best wishes

      Reply

    • Hello

      Our templates are tested on MS Excel. Some features would not work on Google Sheets.

      Best wishes

      Reply

  • My office has 2nd and 4th Saturdays off. How do I change that setting in the excel sheet?

    Reply

    • Thanks for using our template.

      Since these Saturday offs are not every week you need to declare this as leave and allocate each employee a leave.

      Best wishes

      Reply

  • We have a RDO (Rostered day off) company wide every second Friday. Is there a way to apply the N/A function to these days? Or another method we could try (aside from entered a leave day for every employee, every 2 weeks?)

    Thank you

    Reply

    • Thanks for your message.

      Since it just a day in the month, you can declare it as a holiday in the settings.

      Best wishes

      Reply

    • Can you please provide some more details on what you mean by custom holiday dates? We can enter any holiday dates in the holidays table.
      Best wishes.

      Reply

    • Thanks for using our template.

      Please define each holiday separately in the settings sheet. That should work.

      Best wishes

      Reply

  • Is there any way to make this work on google sheets? Im looking to track time off with multiple users inputing data at the same time

    Reply

    • Thanks for using our template.

      Our templates are not compliant with Google Sheets.

      Best wishes

      Reply

    • Please try this in Microsoft OneDrive and Excel Online. This is not compatible with Google sheets.
      Best wishes.

      Reply

  • The Template is exhilarating. Could you guide me, how to change the year from 2016 to 2019, editing the months and to change the formats as per Indian leave system?

    Reply

    • Thanks for using our template.

      Please download the template without any data and enter the your data as advised. You can use it for the current year.

      Best wishes

      Reply

  • Can you copy and paste data in the leave tab from another source/report? I can type it in with no issues but when I paste date in, hen, the events do not populate in the employee report.

    Reply

    • Thanks for writing to us.

      All data needs to be entered manually. If you are pasting data, for instance, the date, please ensure that the format of the date should be correct.

      Best wishes

      Reply

  • Do I just insert new rows with the employees name? Regards
    Also how can we view a yearly overview.

    Reply

  • Hi
    If you take 5 days annual leave and need to take another 3 days annual. How do you enter this
    as it deletes the older 5 days taken on the chart.
    i.e. When i enter the start date and end date in the same cells used initially.
    Please assist

    Reply

  • In our company some employees work on Saturdays while other don’t. So the weekend is not the same for everybody.
    What to do?

    Reply

    • Thanks for using our template.
      The weekly off has to same for each employee. In your case, you may assign a weekly off to each employee separately and mention the same in leaves tab.

      Best wishes

      Reply

  • Is there a way to reflect the annual consolidated employee report to summarize and do comparison per employee?

    Reply

  • Great template. It would be good to be able to send a notification when a vacation date is near due or due

    Reply

    • Thanks for your positive feedback.

      The template does not interact with any external email or messaging systems. Hence, a notification cannot be sent to an external system.

      However, one can filter the data to see the upcoming leaves.

      We will try to incorporate these features in future releases.

      Best wishes

      Reply

  • Tnks for this template.

    I have working whit it to manage a small group almost a year and its great and easy too use!

    Reply

    • Thanks for your encouraging comments. We will try to add more features in future releases.

      Reply

  • Hello after I added leave after line 55 the stopped showing up on the dashboard and advise?

    Reply

    • Thanks for using our template.

      Please ensure you stretch the table down so that the related formulas can be copied below.

      Best wishes

      Reply

  • Hello

    Can you advise on how to change the Employee Report tab so that the weekends line up (like the team dashboard tab)?

    Thanks,
    Savanne

    Reply

    • Hello

      The Employee Report is created for a year, where you can select an employee and see the leaves availed in the calendar year. While the team dashboard shows the days worked for all the employees in a calendar month.

      Best wishes

      Reply

  • Hi there,
    the template is amazing, really easy to use. One question, my employees have 21 PTO per year, can extra days be added to the calculator? It looks like it’s blocking after 12 days.

    Reply

    • Thanks for sharing your positive experience.

      Please ensure that you have filled the correct data in the Settings tab.

      Best wishes

      Reply

  • Hi! Your template is excellent. I enjoy using it. I have already managed to add two extra types of leave to your template that I am using. I was trying to add the eighth one but am unable to. Can you help, please?

    Reply

    • Thanks for your feedback.
      Please clarify how you added the two and the third one.
      Best wishes.

      Reply

      • I went to the Settings sheet and added two additional rows to the ‘Leave Type’. I named the two additional leaves as Biz Travel and 2 hrs Leave.

        Next, I went to the Employee sheet and pasted =IFERROR(INDEX(L_LEAVE,5),””) adjacent to the existing five leave types. I changed the 5 to 6 and 7 respectively.

        Then chose the colour setting in Conditional Formatting. Voila!!

        Thanks to your training provided on top.

        Reply

  • Hi

    how do we calculate annual leave balance ? and carry forward to next year .

    Regards
    Anu

    Reply

  • Hi, if you have a global team. Team PAK and Team PHI – how can you have the PAK holidays reflect to Employees based in PAK and vice versa?

    Reply

    • Thanks for your message.

      As you define the weekends and holidays, the template calculates the rest. If you have two different sets, please use separate templates.

      Best wishes

      Reply

  • Hello Mr. INDZARA.COM
    It is an excellent tool for vacation tracker. It is really helpful in day to day work, thank you for sharing.
    I have one question, Is it possible to force the leave type :vacation, so that despite having a holiday or a weekend day the vacation are overwritten?

    Best regards,

    Reply

    • Thanks for using our template and sharing a positive experience.

      This template identifies the weekends and holidays as mentioned in the settings. Hence, the priority for these is higher.

      Best wishes

      Reply

  • Hi

    I like how we can do a monthly summary for each employee, is there a way of getting a monthly/annual summary showing all employees at once?

    Reply

    • Thanks for sharing your feedback.

      The annual summary of all employees is not a feature yet. We will try to incorporate it in the next release.

      Best wishes

      Reply

  • Hello, thank you for creating this, but I’m BEGGING for a Google Sheets version of this tracker. All attempts at trying to convert this one has failed miserably. I need a tracker that multiple managers can access at the same time and I’m losing my mind trying to find one as good as this (hint: there are virtually none).

    Reply

    • Thanks for your message.
      We have designed our templates for MS Excel. We do not have a Google Sheets version yet.

      Best wishes

      Reply

  • Hi, this is really a very useful template. I would like to add a new column in the “Team Dashboard” and Employee Report sheets. A column which automatically calculates the leave balance for every month based on the accrued leaves for each employee record.

    Might be we can define in the settings the leave policy, please advise.

    Reply

  • Is there any option to use this tracker with a team that has different “weekend days?” Our employees all work different days because we are open every day of the year.

    Reply

    • Hello

      This template is designed for a fixed weekend. In case you are open on all days, please mention the leaves including the weekly off for each employee in the leaves sheet.

      Thanks

      Reply

  • Hi, It is possible to increase the leave type to 8? How can I do so?

    Reply

  • Hi , it’s an excellent report. Need yearly summary for all employees together like monthly employees dashboard

    Reply

  • I am setting up the “Employee Vacation Tracker to track leave & attendance – Calendar & Report”. It looks like it will be exactly what we need. I entered the employee names and start dates, but they all show as “not employed” on the team dashboard. I am sure it is a case of my failing to enter some field.
    Could you suggest what I might have missed?

    Reply

    • I found the problem solved itself when I went to the right year as opposed to the default “2016”! 🙂
      Great program! Thanks

      Reply

    • Hello

      Thanks for using our template.
      Please ensure you have entered all the required fields. In case the problem persists, please email your file along with the list of issues to contact@indzara.com

      Best wishes

      Reply

  • Is there anyway to populate more than 5 leave types, my org has upwards of 7 leave categories.

    Reply

    • Hello

      As of now, we have 5 types of leaves, we might add more in future releases.

      Best wishes

      Reply

    • Hello

      All the leaves for an employee are added in the leaves tab. You need to mention the dates and the type of leave availed.

      Thanks

      Reply

  • Hello,

    Please help me. The colour combination in my dashboard and employee report sheet are not working

    Reply

  • Hello,

    Thank you for this piece. It would make work easier. But my dash board is not working as the colors are not appearing to differentiate the various leave days. Please help.

    Reply

  • Hi Sir,
    This is really excellent Tool provided by you. I need one support in this Tool that I have to maintain attendance of my 5 branches. If I get the column (BRANCH) after employee name than it will be more useful for me else I will have to maintain separate sheets for separate branch. By the BRANCH column I can use filter to take specific branch reporting.
    I will be highly thankful to you if you facilitate me by providing this change.

    Regards
    Suresh Narwani
    Group Co-ordinator
    Raj Public School, Beawar

    Reply

    • Thanks. This is currently not available in the template. However, I am planning to include this feature in a future version (sorry, timeline not available yet for publishing it).
      Best wishes.

      Reply

  • HI,
    there is so much work that has gone into this tracker, its a great piece of work.

    Is it possible to track absence by inputting the leave code directly into the day/month cell. eg, putting ‘S’ into the cell for today 8th April to log an employees sickness today.

    thanks

    Reply

    • Hello

      We have designed this template based on color codes rather than letter codes. We might have something similar in the future.

      Thanks

      Reply

  • I have a few employees who have different weekend days than the rest. Is there a way to update that without having a new form?

    Reply

    • Hi

      This template is designed to have a fixed weekend. However, you can enter the leaves for each employee and assign a weekly off. However, it would be a lengthy process.

      Regards

      Reply

  • Hi there! Tons of work was put into this!! Thank you!
    I´m currently translating this template into Spanish on my desktop so that it is easier to use in my organization. The text is done and most formulas are translated automatically when I use my Laptop (in Spanish) so it won´t be an issue for user here, all except the month drop down menu on the Team Dashboard. Is there a way I can translate the months there into Spanish? FYI I have very minimal technical knowledge but can follow step by step instructions. =)

    Reply

    • Thanks for sharing your positive experience.
      Month names are stored in the hidden sheet H.They have to be modified.

      Best wishes

      Reply

    • Hello

      We have used the complete date format to do the required calculations. They might get affected if the format is overlooked.

      Thanks

      Reply

  • Hello Indzara,

    This is a GREAT template.
    You’ve put a lot of work into it.

    I have two question:
    1) How can I have assign specific Off-Days for each employee?
    I would like to adapt this for a 24 hour business, like hotel, factory, gas station, fast food, etc.
    2) How can I Hide terminated employees from all dropdown list and team dashboard view?
    I would like to have a cleaner look especially when the dates being viewed are past the termination date.

    Looking forward to your reply,
    Ray

    Reply

    • Thank you.
      By specific off days, do you mean holidays/weekends are different for different employees?
      Hiding or filtering certain employees or employees from a certain department is a feature that will be added in future version.
      These two changes would require significant modifications that cannot be explained in 1 or two steps. Sorry.
      Best wishes.

      Reply

      • 1) I would add a new Leave Type called OFF Day, then assign each employee his/her own Off day.
        This has nothing to do with holidays or weekends.

        2) I would add a column in the Employee list page where once an employee is terminated, the manager could select Hide then this would remove any employee with the Hide next to his/her name to no longer show in any drop down list and the Team Dashboard View.

        Reply

        • Hello

          You can have 5 types of leaves in this template. Off Day can be one of them.

          Once the employee is out of the organization, his/her name will figure in the dropdown on the Employee page. However, you can have conditional formatting to highlight that in the table.

          Best wishes

          Reply

  • Mammooth work!!!
    All I want to know is can I retrieve data from 16th to 15th of two months?

    Reply

  • This is very helpful and user friendly, thankyou so much. Just stuck on entering of leave data, lets say an employee takes leave for 5 days in January and then later takes 5 days march, does that imply making 2 separate entries for the same employee?

    Reply

  • Hello great template,
    Is there a way to add to the existing 5 types of leaves such as : Sick, Vacation, Half day, Other, 2 hour block, Bereavement, No charge, Pending. ?

    and is there a place to enter next to the employee Name and Leave table to drag and drop email requests for time off and jpeg so that there is a hard copy record if needed. Right now I do this on my tracker by going to Insert> Object>Create from file>Browse tot he file
    I get employees that always email me there requests for those days off?

    Reply

    • HI I was able to add what I needed but I noticed you have a problem with the form.
      When you pull the employee report and say the year 2016 and name of employee 1 and End date 3-14-2019

      it show only the correct value for the year 2016

      why not the value entered in Jan 5 2019 ? after all why have the END DATE and YEAR? should it not give the entire value?
      I all so noticed it tracks from January to end of December why not from the month the person started? since many vacations are determined by that, are they not?

      I added screen shots below:
      https://ibb.co/y5FQq61
      https://ibb.co/5KDKm3j

      Thanks

      Reply

      • Thanks. Glad to hear.
        1. Employee report is an annual report and hence does not go past 12 months at a time. End Date is useful to limit the end date within the 12 months.
        2. I agree that in some companies it will be better to start the report from some other month than January. I will try to implement that in a future version of the template. Formulas have to be modified to implement that.

        Best wishes.

        Reply

    • Thank you.
      1. A course with step by step instructions on how to build the template is available here: https://courses.indzara.com/p/vacation-attendance-tracker-dashboard-in-microsoft-excel
      That would explain how to add leave types.
      2. The template is not designed to store the images/emails related to time off requests. However, you can insert images and link to specific time off requests. The file may become bulky quickly. or you can enter hyperlinks to external files.
      Best wishes.

      Reply

  • Greetings,

    This worksheet is great, but I’ve been asked to had a feature and wondering if it’s possible to get the formula. Our office is not allowed to have more than 10% on leave on any giving day. Is there a way to add a counter at the bottom of the “”team dashboard” that will count the number of cells that indicate leave for that day?

    Reply

    • Thanks.
      Are you looking for count of employees on vacation for every single day? COUNTIF function should work.
      Best wishes.

      Reply

  • Hi

    Some employees have more annual vacation leave then others, how can I manage that in the spreadsheet

    Reply

  • Hi team,
    There is such nice work by indzara, there is some problem in editing. I want to edit the ” EMPLOYEES” sheet in Attendance tracker and wanted to add one more column in which I can add Employee Code. So help me out with this, how I can make changes in a particular worksheet and wanted to get automatically update that (Employee Code) column in every necessary place, means near to every employee name there should be a suitable employee code. Thank you.

    Reply

    • Thank you.
      Yes, you can insert a column and then use the INDEX and MATCH functions in a formula to bring over data from the EMPLOYEES sheet.
      Thanks & Best wishes.

      Reply

  • Hi team,
    There is such nice work by indzara, there is some problem in editing. I want to edit the ” EMPLOYEES” sheet in Attendance tracker and wanted to add one more column in which I can add “Employee Code.” so help me out with this, how I can make changes in a particular worksheet.

    Reply

  • Hi,
    This template is good, thanking you.
    but i have one problem,
    we are two Employee has a 6 day work per week
    Then how to change holidays to working days
    please
    Thanks.

    Reply

    • Hello

      The template is designed to have a fixed weekly off. In case few employees work 6 days a week, then you need to have six days week for all and mark a holiday for all those employees who do not work on the 6th day.

      Best wishes

      Reply

      • thanks you
        but i want to enter extra working one employee in leave day.
        how to remove Sunday block function.
        thks

        Reply

  • Hi it is very useful. However, we need one more button to include is for approval of annual leave (and all other types of leaves). because it is necessary for a manager.

    Reply

      • Sorry about the delayed response. Somehow missed this comment.
        The template does not address approval of vacation. It only tracks approved vacation entries.
        Best wishes.

        Reply

  • Hi,

    It’s really helping but I already key in more than 5 leave type but at the team dashboard only appear 5 only so how to make it all appear the leave type that I key in ? Anyway, how to make multiple leave vacation because I need to handle staff at office and site project but need to include in 1 excel as their working day is total different with office. Thank you.

    Reply

    • Thanks for using our template.
      This template is designed to handle 5 types of leaves. We might come up with an updated version to handle more types.

      Best wishes

      Reply

  • hi

    it is very very outstanding sheet I really appreciate your work but, I had one issue; when I change the year to 2019 calendar I don’t get weakend highlighted same as 2018 however i have already choosed my holidays and weakened days. In addition,it is not calculating if 1 employed goes for more than vacation

    Reply

  • I am using this program but the only thing showing up on calendar is vacation information I put in not sick leave or anything else

    Reply

    • Hello

      Thanks for using the template.
      Please ensure the formulas are not intact. In case the problem persists, email the file along with the list of issues to contact@indzara.com

      Best wishes

      Reply

  • Hello. Our leave is calculated in 1 hour increments not in days. How can I change the spreadsheets to reflect this? Thank you.

    Reply

    • Hello

      You can extend the leave types table and add more types. Ensure that in the team dashboard too you create a color scheme for that type of leave.

      Best wishes

      Reply

  • I am having issues with my conditional formatting. In some cases I have staff that are on annual leave but also a public holiday is part of the leave period. Due to having staff in different states I have included a public holiday leave type which I key in different public holidays separately. However when I also key in annual leave the same cell which has a public holiday and annual leave day only shows up in the employee report at a white cell with neither leave being counted. I have been trying to get the public holiday to be the main type however even when I move them around in Conditional formatting rules and also selecting Stop It True I it does not work. Please help.

    Reply

    • In the Leave Tracker template, the order of preference is done in the formula and not in the Conditional formatting rules. Only one conditional formatting rule will be valid for a given cell, so the order of the rules will not matter. We need to address this in the formula entered in the cells (not the cond formatting).
      I have also replied to your email with these details.
      Please let me know if any questions.
      Best wishes.

      Reply

  • Hi this excel sheet looks amazing! I would like to use it for my staff of 50 employees. However we do a lot of 0.5 and 1 days and have 12 leave types to reflect the 0.5 and 1. I have tried to follow your instructions on adding more leave types however I am not the strongest in excel. Are you able to upload another version with at least 10 leave types ( I see some people have been asking for more types). This would be really helpful!!

    Reply

    • Thank you.
      I will do my best to publish a template which supports more leave types.
      Best wishes.

      Reply

  • I love this spreadsheet – it works perfectly for our small business. Is there a way to add 2 columns – one indicating how many vacation days each employee is entitled to, and a second that would auto calculate how many days they have left based upon those taken? Where do you suggest adding these and what is the process? Thank you!

    Reply

    • Thanks for using our template and sharing a positive experience.

      This template is designed to capture the leaves that an employee avails during a calendar year. It would not be able to account the leaves carried from previous years. However, we have a well-designed premium PTO template that can suffice your requirements. Please review our “Small Business – Paid Time Off (PTO) Manager – Excel Template” at https://indzara.com/product/small-business-paid-time-off-manager/

      Best wishes

      Reply

  • Good day
    The sheet is not calculating correctly, it shows that my employee is not employed but is.
    all the leave input is not counted in the Team dashboad, as some employees has sick leave but is not showing in the team dashboad or on the employee report. it shows that the employee has not gone with leave “0” but the employee has gone on leave.

    Please help

    Reply

  • Hi Indzara!
    This is such an amazing excel template! Very useful. I am looking to have a different weekend for everyone. In my company, we have different working days. Eg. Employee 1 will be off Sunday and Monday, Employee 2 will be off Sunday and Tuesday, etc. Is it possible to do that with this template? Thank you.

    Reply

    • Thanks for your feedback.

      This template is designed to have a fixed weekly off.

      Best wishes

      Reply

  • Hi,
    This template if magnificent! I need something that calculate the vacation of the staffs per colleague.
    For example
    Employee 1 – he has a 6 day work per week so he is entitled of 1.56 vacation day per month
    Employee 2 – has a 5 day work per week so and entitled of 1 vacation per day
    Then on a separate data, there are estimated 9 holidays in the calendar as per UAE (just an example) I would like to track also their holiday apart from their annual leave.

    Please assist.

    Thanks.

    Reply

    • Hello

      A single logic can be applied in a template. In this case, you have to duplicate the template for each group.

      Best wishes

      Reply

    • Hi Everyone and Admin,

      how to do it.

      My question – if the worker came late is there a way to record it.
      n how if he/she applied 0.5 or 1 hr leave.
      coz in my company got this problem

      Reply

        • Hello

          The present version can accept 5 types of leaves. We might have more in the future releases.

          Thanks

          Reply

      • Thanks for your query.
        You are correct. Adding a different leave type to track partial vacations should work.
        Best wishes.

        Reply

    • hello hai,
      are you complete your question how
      please help me
      how to change holiday to working days
      thanks.

      Reply

      • Hello

        The template is designed to have a fixed weekly off. In case few employees work 6 days a week, then you need to have six days week for all and mark a holiday for all those employees who do not work on the 6th day.

        Best wishes

        Reply

  • Hi
    I’d like to appreciate this great work.
    Can I change the Gregorian calendar to Umm al-Qura Calendar? As it is the official calendar in my place.
    Thanks

    Reply

    • Hello

      You may format the dates to suit your local requirements. However, please ensure that all date columns are formatted.

      Best wishes

      Reply

  • Hi

    1. How to change the “work days” calculation to entitled leave day? if every month the staff will entitle one leave day which means in 12 months they will entitle 12 leave days.

    2. Just say, one of the staff started in the middle of the year (e.g. May) and will entitle the leave day in August, what formula should i used? (this refers to my question no. 1, in which i need to change the working days monthly to “entitled leave day”

    Reply

    • Hello

      For questions related to earned vacation/pto/leave or entitled vacation/pto/leave or balance vacation/pto/leave, please refer to PTO Calculator (Free) and PTO Manager (Premium) templates.

      Best wishes

      Reply

  • Sorry to add another comment. I forgot to ask:
    How can I add calculations for the whole team leaves? e.g,

    – employee 1 got 2 sick leaves, and 1 unpaid / month
    – employee 2 got 1 sick leave, and 3 unpaid / month
    the result will be:
    the team got 3 sick leaves and 4 unpaid leaves / month

    Reply

  • Thanks for this amazing tracker.
    How can I add more than 5 leave types?
    +
    is there a way to put the date without having to type it every time?

    Reply

      • Please do the following to add more leave types.
        1. Just type sixth leave type in SETTINGS sheet’s Leave type table.
        2. In the TEAM DASHBOARD sheet,
        a. Edit conditional formatting rules. You will see rules for the 5 colors.We need to create a similar rule. The formula for the sixth color is =C8=INDEX(L_LEAVE,6).
        Apply this to all the cells in the calendar.
        b. Insert a column between columns AM and AN. This new column is to calculate the sum for sixth leave type for each employee.
        c. In that new column, we need to enter formula. You can copy formula from cell AM8 and paste in AN8(newly created column). Then drag down the cell to row 37 to copy the formula for all employees.
        d. In the Total Leave column, edit the formula to sum all the 6 leave types (by default it was for 5 leave types).
        3. In the EMPLOYEE REPORT sheet,
        a. Edit conditional formatting rules. You will see rules for the 5 colors. We need to create a similar rule for the sixth color. Apply this to all the cells in the calendar.
        b. Insert a column between columns AN and AO. This new column is to calculate the sum for sixth leave type for each month.
        c. In that new column, we need to enter formula. You can copy formula from cell AN12 and paste in AO12 (newly created column). Then drag down the cell to row 23 to copy the formula for all months.
        d. In the Total Leave column, edit the formula to sum all the 6 leave types (by default it was for 5 leave types).
        These steps above should implement one additional leave type. You can repeat the same for more additional leave types as needed.
        Please try and let me know if there are any questions.

        Also, we might have a feature to select a date from a calendar in the next release.

        Best wishes

        Reply

    • Please do the following to add more leave types.
      1. Just type sixth leave type in SETTINGS sheet’s Leave type table.
      2. In the TEAM DASHBOARD sheet,
      a. Edit conditional formatting rules. You will see rules for the 5 colors.We need to create a similar rule. The formula for the sixth color is =C8=INDEX(L_LEAVE,6).
      Apply this to all the cells in the calendar.
      b. Insert a column between columns AM and AN. This new column is to calculate the sum for sixth leave type for each employee.
      c. In that new column, we need to enter formula. You can copy formula from cell AM8 and paste in AN8(newly created column). Then drag down the cell to row 37 to copy the formula for all employees.
      d. In the Total Leave column, edit the formula to sum all the 6 leave types (by default it was for 5 leave types).
      3. In the EMPLOYEE REPORT sheet,
      a. Edit conditional formatting rules. You will see rules for the 5 colors. We need to create a similar rule for the sixth color. Apply this to all the cells in the calendar.
      b. Insert a column between columns AN and AO. This new column is to calculate the sum for sixth leave type for each month.
      c. In that new column, we need to enter formula. You can copy formula from cell AN12 and paste in AO12 (newly created column). Then drag down the cell to row 23 to copy the formula for all months.
      d. In the Total Leave column, edit the formula to sum all the 6 leave types (by default it was for 5 leave types).
      These steps above should implement one additional leave type. You can repeat the same for more additional leave types as needed.
      Please try and let me know if there are any questions.

      This template is designed to track leaves for each individual in a team/ organization. However, you may add the columns for each leave type to get the totals of each type availed in a month by the team or organization.

      Best wishes

      Reply

  • HI. Great template.

    Question: My monthly cut-off starts on the 29th of the month and ends on 28th of the next month (ex. July 29- August28). What formula should I use??
    And another one is if I set my weekend on Sundays but some employee go to work on Sundays, how will it possible to count their work day??

    Thank you.

    Reply

    • Thanks for using our template.

      This template is for a calendar month. An overlapping cycle would be a challenge.
      The weekends are fixed for everyone in this template. In this case, you can assign weekly off to each employee differently. However, make sure that weekly off has to be mentioned for all.

      Best wishes

      Reply

  • HI. Great template.

    Question: My monthly cut-off starts on the 29th of the month and ends on 28th of the next month (ex. July 29-August28). What formula should I use??
    And another one is if I set my weeken on Sundays but some employee go to wotk on Sundays, how will it possible to count their work day??

    Thank you.

    Reply

  • THIS ROCKS!!! It is seriously like 98% PERFECT for what I needed 🙂 The only ONE thing I cannot seem to figure out is how to change the YEAR field to a START DATE field. I need the leave to be calculated from October 1, 2018 – September 30, 2019 (FISCAL YEAR, not CALENDAR YEAR). I can enter the end date, but cannot for the life of me figure out how to change the formula in B4 from I_RPT_YR to an editable date. Please advise. Thank you for creating such an amazing document! If I can figure out this one thing, using this will save me from DAYS and DAYS of trying to build my own.

    Reply

    • Thanks for the positive feedback. Glad to hear that it is useful.
      Changing the start date is more involved than just changing the cell B4. We need to edit the cells A12 to A23 to calculate the month. We need to edit the cells C12 to AG23 (they all use same formula). They use the Year and cells A12 to A23, to calculate each date and then find vacation/leave for the specific date.
      Thanks & Best wishes.

      Reply

  • nice program but how will I know the remaining leave for each employee. Explain an employee took 5 days from 15 days vacation leave how will I know the rest the leave remaining..thx

    Reply

    • Thanks for the positive feedback.

      You can add a column to the employee report tab, which will deduct the leave availed in a month from the balance available.

      Best wishes

      Reply

  • Hello
    You have an amazing template
    How can the template work it different employees have different weekly offs.

    Reply

      • Hello,

        This template is designed to track the number of days an employee works or takes leaves.
        The calculating unit is days.

        Best wishes

        Reply

        • Hello, How can the template work if employees have different week off?

          Reply

    • Hello

      Thank you for using the template.
      In case the weekly off is different for each employee, then it needs to be fed in the Leave tab for each weekly off. Which is practically not feasible.

      Best wishes

      Reply

  • Hi, your template is awesome, but i need annual report for all employees in one sheet, how can i develop this functionality? Is any way to get all this data rady for printing?

    Reply

    • Hello

      Thanks for the positive feedback.

      The data for a year is available in the “Employee Report”. However, same for all employees in a single sheet might be featured in the next release.

      Best wishes

      Reply

  • Hi

    If i want to find total leaves taken in a year employee wise in a separate sheet how can I get this.?

    Reply

  • one more question sir, how to count number of working days for current date or today ?
    thanks before sir

    Reply

    • Can you please clarify your question? with an example, if possible?
      Thanks & Best wishes.

      Reply

  • I want to thank you for an awesome calendar!! Is it possible to add another column to the “Leave Data” for remarks and then dynamically display the remarks over the dates of the event. For example if Employee 1 is on vacation form 1-10 August 2018 to Disney Land and they added the remark “Disney” in the “Leave Data” remarks column it would display Disney over the dates of the vacation.

    Reply

    • The data for the kind of leave is defined in the settings. Hence, it would be a vacation and not a destination where the employee spends their vacation.

      Regards

      Reply

      • How can i add more leave to the template?5 leaves seems not enough for the leaves.

        Reply

  • I absolutely love this worksheet. there is one additional sheet I’d like to see added. An annual PTO sheet listing each employee, all the months across with 3 columns under each month highlighted with the PTO color and the 3 of pto used in the particular month and a total column.
    anyway that can be added?

    thanks
    Gavin

    Reply

    • Thanks for your positive feedback.
      The details for each employee is available for the year.

      Best wishes

      Reply

  • thanks for this amazing template ..
    i wanna ask how to exact the drop down data into table ? i wanna make a chart, and i wanna find whos the top leaves data..
    thanks before man…

    Reply

    • Hello

      To find the top employee based on the number of leave days, we can add a column and use the rank function.

      Best wishes

      Reply

  • How do I add more Leave Types? Is there a paid version that offers more than 5?

    Reply

    • Thank you for using our template.

      The present version can accept 5 types of leaves.

      Best wishes

      Reply

  • Thank you first for your work. I need your support in a way. I want to explain. Team DashBord page is gray at weekends. sometimes employees can work at weekends. but the gray color does not change. For example, overtime may be overtime. Could we show him as the other? as a result the gray color will change at weekends and will not write wknd in the cell. can you help me?

    Reply

    • Hello
      Thank you for your kind words.
      A weekly off defined & declared holiday is applicable to all the employees. In case some people work on the declared weekly off, you can take the following steps:
      1. Not have any weekly off in the organization.
      2. On the leave sheet, list the weekly off for each employee separately.

      Once you take these two steps, your issue will be solved.

      Best regards

      Reply

  • Hi Team,

    This is very useful file you have created for small business owners to reduce cost by purchase any paid software, i my question is how can i change the start date as April 01 instead of Jan 01 & end a March 31st.

    Glad to hear from you on this.

    Reply

    • Hello,

      Thank you for your kind words.
      This template is designed for a calendar year.

      Best wishes

      Reply

  • Hi,
    I forwarded this template and the Team Vacation Planner Excel Template to my boss. She loves both of them, but slightly prefer this template.

    My questions are how can I introduce three functions of Team Vacation Planner template (https://indzara.com/product/team-vacation-planner-excel-template/) into this template?
    1) to set April 1 as started date instead of Jan. 1?
    2) to set different work schedule to each employee (because some employees work part-time at our office)
    3) to set different number of employee needed every day (because some employees work part-time at our office)

    Thanks a lot!
    Wamy

    Reply

    • Thanks for your kind words. Glad to hear.
      The changes require significant development effort. Sorry that we cannot make the changes immediately.

      We will consider your feedback to improve the products in future.
      Thanks for your feedback. Best wishes.

      Reply

  • I REALLY LOVE THIS…ONE THING I’D LIKE TO SEE IS AN ANNUAL SUMMAR FOR THE TEAM DASHBOARD RATHER THAN JUST THE CURRENT MONTH. IF I WANTED TO SEE ALL EMPLOYEES YTD DATA IN ONE PLACE. A COLUMN FOR THE EMPLOYEE NAMES, A COLUMN FOR THE YTD VACATION/TIME OFF.
    THANKS

    Reply

  • Hi, This template is great! however I don’t know how to go about adding more Leave Types. Able to guide me on this?

    Reply

  • Hi,

    Could you please inform how I can change the formulas in the calendar, as in my country the calculation of the vacation, sick leave etc. days are not the same. For example, Saturday and Sunday included for vacation days.

    Reply

    • Hello

      You have checkboxes on the day of the week. You can select the day of your weekly off.

      Best wishes

      Reply

  • HI ,

    The sheet is very usefull ,
    can you please let me know how to see quarter wise view in Team Dashboard
    like jan feb mar
    etc

    Thanks In advance

    Reply

    • Hello

      This feature is not available now. We would definitely try to incorporate it in our next release.

      Best wishes

      Reply

  • Hi. please help me with this, below is the sample
    date of sick leaves ———————— total days of SL—————– remaining days of SL
    (1/5/2018), (4/5/2018), (7/5/2018) ?????? ??????????
    I just want to know what are the formulas to use in “total days of SL” if it is counted as “3” and in “remaining days of SL” counted as “12” since in one year, from the date of joining, it is only allowed 15days for Sick Leave. please help me………

    Reply

  • Could you help me to incorporate the calculations of Overtime per employee in this template

    Reply

  • How to Add additional leave? i need additional 2 (Paternity and Maternity)

    Reply

    • Please do the following to add more leave types.
      1. Just type sixth leave type in SETTINGS sheet’s Leave type table.
      2. In the TEAM DASHBOARD sheet,
      a. Edit conditional formatting rules. You will see rules for the 5 colors.We need to create a similar rule. The formula for the sixth color is =C8=INDEX(L_LEAVE,6).
      Apply this to all the cells in the calendar.
      b. Insert a column between columns AM and AN. This new column is to calculate the sum for sixth leave type for each employee.
      c. In that new column, we need to enter formula. You can copy formula from cell AM8 and paste in AN8(newly created column). Then drag down the cell to row 37 to copy the formula for all employees.
      d. In the Total Leave column, edit the formula to sum all the 6 leave types (by default it was for 5 leave types).
      3. In the EMPLOYEE REPORT sheet,
      a. Edit conditional formatting rules. You will see rules for the 5 colors. We need to create a similar rule for the sixth color. Apply this to all the cells in the calendar.
      b. Insert a column between columns AN and AO. This new column is to calculate the sum for sixth leave type for each month.
      c. In that new column, we need to enter formula. You can copy formula from cell AN12 and paste in AO12 (newly created column). Then drag down the cell to row 23 to copy the formula for all months.
      d. In the Total Leave column, edit the formula to sum all the 6 leave types (by default it was for 5 leave types).
      These steps above should implement one additional leave type. You can repeat the same for more additional leave types as needed.
      Please try and let me know if there are any questions.
      Best wishes.

      Reply

  • Hello,

    This is an awesome template. Thank you very much for creating it. I too would like to have it available for google Sheets, as we work our platform over this. Do you know if this will come soon? Would you create a paid version?

    Thanks

    Reply

    • Hello
      Thanks for the positive feedback.
      Some of the important features of this template do not work on the Google Sheets. Hence, you are advised not to use Google platform.
      Thanks & best regards

      Reply

  • Hi there.

    I would like to add job title and designated branch at the “Employees” and “leave” sheets. How can I do that?

    Thank you.

    Reply

    • Hello,
      This feature is not available in the current template. However, the reports in the Team Dashboard and Employee do not use Designation and Job title.
      Thanks & regards

      Reply

  • Thanks a lot, please tell me how to add many leave records in the same month.

    Reply

    • Hello
      Thank you for using the template.
      Please enter each leave day separately. We can add one record to the table for each day.
      Best wishes

      Reply

  • HI , can i put in words like MC for medical leave instead of putting colors on the dashboard calender?

    Reply

    • Yes, the words are already there. The font color was chosen as the same as fill color and hence we cannot see the word. Please edit the conditional formatting rules and change the font to white or black.
      Please let us know if there are any questions.
      Best wishes.

      Reply

  • Hi there,

    It is understood that cumulative leave taken up to the current selected month is not applicable for the dashboard.

    However I noticed that the “Employee Report” worksheet display the total leave taken for the selected employee. Is there any way I could carry/link this value to display in the Team Dashboard (for particular employee)?

    Thanks.

    Reply

    • Thanks.
      In this design, we calculate for each day whether the employee has a leave or not. Then, we add all the days available in the view to get the total.
      In the ‘Team Dashboard’ view, we only calculate for one month, but for all employees. In the ‘Employee Report’, we calculate for one year, but for only one employee. Even if you link the value, it will be only for one employee.
      We need to redesign to allow for all employees’ to show total cumulative leave. If you are tracking for only few employees, you can duplicate the Employee report sheet (carefully without impacting formulas) and then can link them to the Team Dashboard.

      Best wishes.

      Reply

  • Hi INdzara,

    May i know how (formula) to sum up total leave used to date from the team dashboard?
    example: Staff A took 10 days leave on Jan, when i select feb how to show this 10 utilised leave from Jan in my Feb sheet ?(I am adding a column in yout dashboard)

    Reply

  • Good day ,

    I would please like to add a leave count from the previous year.

    Meaning some of my employees has been working for over ten years and over December did not use all there leave.

    So they start with 4 days leave 1 Jan .

    Would it be possible to add a column on the each on the Jan month to add existing total and then take if from there.

    kind regards

    Reply

  • When I upload the file into google sheets the formulas dont work anymore. I did all defined range names as done in excel in Google Sheets but the formulas in Team Dashboard dont work.

    =IFERROR(IF(C$7=””,”NA”,IF(C$70,C$7>rrayFormula(INDEX(T_EMP,1,3)),”NE”,IF(NOT(ISERROR(MATCH(C$7,L_HOLS,0))),”H”,IF(INDEX(L_WKNDVAL,WEEKDAY(C$7,1))=1,”WKND”,index(arrayformula(INDEX(T_LEAVE,1,4)),SUMPRODUCT(–(arrayformula(index(T_LEAVE,1,1))=$B8),–(arrayformula(index(T_LEAVE,1,1))=C$7),ROW(arrayformula(index(T_LEAVE,1,4))-ROW(arrayformula(index(T_LEAVE,1,4)))))))),””)))))

    The problem is that I dont get H when its holiday and Weekend when its a weekend! The rest works fine!

    Reply

    • Hello,
      This template is designed to work on Desktop or OneDrive. You will encounter errors when using it over Google Sheets.
      It’s not compatible with Google Sheets.
      Best wishes

      Reply

        • Hello
          At present, our templates are not compatible with Google Sheets.
          We might incorporate this feature in our next release.
          Best wishes

          Reply

          • Ooh. Hope this update will be available the soonest!

            However, I have a question:

            When I encode the leave it doesn’t appear on the day the leave should appear. For example, all entries on March 1 is not visible but the rest date in March is good and visible. Hope you can extend your help.

            Thanks again.

          • We would also love the ability to utilize this is google sheets. I love the layout and capabilities of your template — thanks! I want to be able to share it with a few employees and we use the google suite.

          • Hello,
            Some important features of the template do not work on Google Sheets.
            Best wishes

  • Hello, Great Spreadsheet. Is there a way to use hours instead of days . Without having to make a leave type for each hour of the work day?

    Reply

  • Hi, Please am trying to apply the below instructions but am not getting it right. Kindly assist.

    Thank you.

    Please look at the Conditional formatting rules. We have used the color fill (same color as font) to make the text invisible. You can edit the rule and apply a different font color.

    Reply

  • Hi

    thank you for your great effort and really appreciate all your work.
    I m working as HR accountant in a medical center and working everyday without off. i need to add more options as
    1. Every employees have different week off, how to manage ?
    2. Those who are working public holidays it will be compensated as Comb.off, how to manage
    3. how to add employee id other than entering name

    please guide me how to edit the file or please send to me updated file as above

    thank you very much

    Abdul Aziz

    Reply

    • Thank you for sharing your queries.

      1. This template is not designed to handle different weekly offs.
      2. Compensating public holiday with a comp off is not part of this template.
      3. You can add Employee id in place of employee name.

      We have noted the issues raised by you and will try to accommodate them in our next version.

      Regards

      Reply

  • INDZARA, MANY MANY THANKS FOR YOUR GREAT EFFORT.
    PLEASE I NEED YOUR HELP !! IN #EMPLOYEES SHEET, I NEED TO ADD ” JOB TITLE ” AND ” WORKPLACE ”
    ( SAY INSTEAD OF START/END DATE HEADERS )
    AND LATER TO SORT EMPLOYEES IN #DASHBOARD SHEET ACCORDING TO THEIR JOB TITLE/WORKPLACE ??
    SOLVING THIS WILL SAVE ME ALOT OF TIME TO COMPARE LEAVES UNDER SPECFIC CATEGORY

    THANKS IN ADVANCE

    Reply

    • Thank you.

      Please add columns to Employees sheet. Then sort that table using Excel’s built-in sorting feature. Then, the Dashboard will reflect the order in the Employees sheet.
      Best wishes..

      Reply

  • Hi Indzara,

    Thank you for your response.

    If you help with at least one change to track employee worked in “Day shift (or) Nightshift ” that will be the great help to me. I think we have to use the same logic as we are tracking leave data.

    Please do the needful!

    Thanks,

    Jeevan

    Reply

  • Hi,

    It is really a great template I have ever seen. I’m trying to update two things in the template.

    1) I’m trying to track “Day shift (or) Night shift employee into
    2) I’m trying to track if the employee worked on Holiday.

    Please do the needful to reflect the above two changes in the template.

    Thanks,

    Jeevan

    Reply

    • Thank you.
      Sorry, the template does not handle if employees work on holidays.
      Thanks for feedback. I will try to include that feature in a future version.
      Best wishes.

      Reply

  • Hi Indzara,

    You have made awesome leave tracker, just i was wondering how to show Present as P for working days in the team dashboard sheet. I have seen you have used “Mod function” for column and row to represent as working days but can u give some solution how to highlight Present as P for working days ? It would be great help from you.

    Regards,
    Rohit

    Reply

    • Thank you.

      Please look at the Conditional formatting rules. We have used the color fill (same color as font) to make the text invisible. You can edit the rule and apply a different font color.

      Best wishes.

      Reply

  • Thanks for taking the time to do this and making it public. It has saved me a great deal of time and is more comprehensive than I could have made it alone.

    I am wondering about the situation where an employee works on a weekend day. Some of our team have to work overtime days on Saturdays or Sundays, but they would still be considered weekends in terms of regular work days/holidays/etc.

    Is there a way to override a weekend day in this scenario?

    Thanks in advance

    Reply

    • You are welcome.

      In this template, we cannot override weekends. Thanks for feedback. I will try to include that feature in a future version.

      Best wishes.

      Reply

  • Thank you so much for the amazing work you’ve done!

    I do have one question so far, in our company Saturday is a working day however it is only for a half day, so how can i make Saturday a working day, but only for a Half day?

    thank you in advance.

    Reply

    • You are welcome.
      Currently that option is not built in this template. Thanks for feedback. I will consider adding that in future.
      Best wishes.

      Reply

  • Hi Indzara,

    this is a fab piece of work, well done, it is very handy. I am fine with all the formulas and formatting just dont get the relation between week days in “H” tab & setting (check boxes). how did you do that, a bit of explanation would be much appreciated as I couldn’t see any link between cells in each tab.

    Thank you

    Reply

    • Thank you. Please right click on the check box. You will see that it is connected to the cell in the hidden H sheet. So, when we check the box, it registers a TRUE in the H sheet B column. If we uncheck, it passes FALSE. I then convert it to 1 and 0 for easier calculations.
      Best wishes.

      Reply

  • Thank you.
    Please provide an example to explain. if an employee takes leave in different (non-consecutive) days, we enter them in separate rows in Leave sheet.
    Best wishes.

    Reply

  • This is one is good. one improvement i required on this is, if one Employee need to take leave on same year different month. then how he can enter that, as this reflects single entry.

    That will be the great feature for this.

    Reply

  • Hi,

    If any one took half day of sick leave then in that case what all changes in formula need to be done so that half day of sick will reflect in sick leave section rather than full day.

    I have created extra label for half day sick .

    Reply

  • Amazing Leave Tracker. Loving it. I was able add additional Leaves as per my organization’s requirement.I have a unique requirement to add the Managers Name against the Employees and a drop down to be created for the Managers in the “Team Dashboard” like month drop down which is currently existing. Please let me know whether that is possible.

    Reply

    • Thank you. I am sure that it should be possible. We would create a drop down following the method used for the Month. Then in column B, we would edit the formulas to only list employees under that selected manager. Then, everything else should work as it is.
      best wishes.

      Reply

    • Sheets are password protected to prevent unintentional editing. The templates will work with the protection. They need to be unprotected only if the functionality needs to be changed. Password is indzara.
      Best wishes.

      Reply

  • Your template is awesome. You are very gifted! Is there a way I can combine the Employee Report and the Dashboard? I have about 100 employees and I need to have yearly totals without having go to each team member one by one. Is there a way I can add in the year to date sum totals. I am using this template for tracking attendance points. I would like to have a running total on the dashboard. It would be great if I could change the dashboard to view more than once specific month. Any suggestions?

    Reply

    • Thank you for the feedback.
      Yes, technically it can be done. It’s hard to explain step by step here. You can take the Dashboard and extend to 12 months instead of 1 month. You can see the formulas used and copy/extend to 12 months.

      Best wishes.

      Reply

  • hank you for you template. It helps me lot. But in my company few of employees are working rosters.based on that few employees working even weekends or holidays too. If i encode leave then it will not as leave day.

    Ex : Employee1 : Applied leave on weekends (Sat & Sunday) (Actually company having 5 working days only )

    Reply

    • You are welcome. If different employees have different working days or if we want to count weekends also as holidays, we have to modify the template. I am sorry that it is not supported.
      Best wishes.

      Reply

  • Hi
    How do I color the calendar for the employees vacation having one type only
    I dont need the sumproduct how to transfer it into if ?

    SUMPRODUCT(–(T_LEAVE[EMPLOYEE NAME]=$B13),–(T_LEAVE[START DATE]=Q$7),ROW(T_LEAVE[LEAVE TYPE]))-ROW(T_LEAVE[#Headers]))))))),””)

    Reply

  • Hi Indzara,

    Thank you for you template. It helps a ton. I would like to know how do we input the holidays for years to come? Do I have to input manually for let’s say a period of 10 years?
    Is leave entitlement for each individual annually is the same format as the PTO?

    Thanks again!!

    Reply

    • You are welcome.
      Yes, you can enter holidays for future years. It will have to be manually input.
      Please explain your last question.
      Best wishes.

      Reply

  • The template is great but I have adapted it to suit my business needs. Instead of ‘leave types’ I am assigning these values to projects/job sites that my employees are working on. With that being said I would like to have more than 5 available ‘leave types’ or in my case ‘projects’ that I can assign their time to.

    How can I manipulate the 5 row table to include more rows with more colors that will be reflected on the dashboard?

    Thanks!

    Reply

    • Please do the following to add more leave types.
      1. Just type sixth leave type in SETTINGS sheet’s Leave type table.
      2. In the TEAM DASHBOARD sheet,
      a. Edit conditional formatting rules. You will see rules for the 5 colors.We need to create a similar rule. The formula for the sixth color is =C8=INDEX(L_LEAVE,6).
      Apply this to all the cells in the calendar.
      b. Insert a column between columns AM and AN. This new column is to calculate the sum for sixth leave type for each employee.
      c. In that new column, we need to enter formula. You can copy formula from cell AM8 and paste in AN8(newly created column). Then drag down the cell to row 37 to copy the formula for all employees.
      d. In the Total Leave column, edit the formula to sum all the 6 leave types (by default it was for 5 leave types).
      3. In the EMPLOYEE REPORT sheet,
      a. Edit conditional formatting rules. You will see rules for the 5 colors.We need to create a similar rule for the sixth color. Apply this to all the cells in the calendar.
      b. Insert a column between columns AN and AO. This new column is to calculate the sum for sixth leave type for each month.
      c. In that new column, we need to enter formula. You can copy formula from cell AN12 and paste in AO12 (newly created column). Then drag down the cell to row 23 to copy the formula for all months.
      d. In the Total Leave column, edit the formula to sum all the 6 leave types (by default it was for 5 leave types).
      These steps above should implement one additional leave type. You can repeat the same for more additional leave types as needed.
      Please try and let me know if there are any questions.
      Best wishes.

      Reply

  • Hi indzara, im trying to make like yours because i dont need some stuff as the termination date and leave type.
    i only have the weekends, holidays, and the holiday date for each employee. please tell me how to do the formula for these in the calender

    Reply

    • Thanks for contacting.

      I am sorry that I am unable to customize the files. The best way to understand how the formulas are built is to review the formulas and edit/test. If you unlock the sheets using the password indzara, you will be able to see the formulas.

      If there is very specific question, I can try to help. But explaining everything will be very time consuming. I am sorry.

      Best wishes.

      Reply

  • Hi,
    Your work is the best i have seen. I want your help on calculating the sick days. In my country the sick days are counting as calendar days no matter if we have WKN or holidays days in the middle. In the template the sick days calculating different. the programma don’t calculate as sick days the weekend or holidays. Which i want too. How can i change it ?
    Thank you very much

    Reply

    • Thank you.
      This will require changing the order in the formula used. In the formula, if it is a holiday and sick day, it is counted as holiday instead of sick day. We have to change that order. You can unlock the sheet with password indzara and make modifications.
      Best wishes.

      Reply

  • Hi Indzara, Firslty I would say that this is an awesome tracker I have ever seen. This is really an amazing work you have done. I am really thankful to you for this leave tracker sir.

    I work in a team where every team member has different week offs. For example Employee 1 has Sat&Sunday as the week off and Employee 2 has Tuesday & Wednesday as there week offs and Employee 3 has Thursday&Friday as the week off.

    In this tracker can we make the changes so that the week offs can vary for different employees. It will really be very helpful if there is a possibility to make these changes.

    Thanks in Advance!

    Reply

    • Thanks for feedback.
      We can make such modifications, but would require some development effort. Unfortunately, I am unable to get to it now. I will look into it in the future.
      Best wishes.

      Reply

      • Hi indzara, im trying to make it but there are some stuff i dont need as the termination date and leave type.
        i only have the weekends, holidays, and the holiday date for each employee. please tell me how to do the formula for these in the calender

        Reply

        • Thanks for contacting.

          I am sorry that I am unable to customize the files. The best way to understand how the formulas are built is to review the formulas and edit/test. If you unlock the sheets using the password indzara, you will be able to see the formulas.

          If there is very specific question, I can try to help. But explaining everything will be very time consuming. I am sorry.

          Best wishes.

          Reply

  • Hello,
    This is a great worksheet, I was hoping to get your help with one addition. In our company every year we each employee gets their agreed upon number of days for vacation and PTO- which roll over for the first quarter each year.
    How can i add a column to this sheet to show how many days are left on an employees total that includes the roll over?

    Thank you

    Reply

  • Hi,

    I have manually entered the employee data and the year – 2017 but i could not see any changes in my worksheet .i selected Friday as weekend but in the sheet it shows Saturday and the calender does not change for the year 2017.

    please help!

    Reply

  • Hi Sir,

    I just wonder if there are many leaves in a month how will I put it there? Please show me. I’ve been analyzoing it but I can’t figure it out on how to put many leaves in one employee only. Looking forward to hear from you soon Sir. Thanks!

    Reply

    • In the Leave sheet, you can enter the leave dates. If an employee takes consecutive days off, then you can enter that in one row (start to end date). If an employee takes days off, that are days apart, then enter in separate rows.
      For example,
      First row: Employee1 start date (Jan 1) End Date (Jan 5)
      Second row: Employee1 start date (Jan 10) End Date (Jan 10)
      Best wishes.

      Reply

  • Hi!
    Thank You a lot for the great template. please help me to indicate the different non working days for employees. For example,to have 3 types- l_wkndval -for Saturday and Sunday, l-wkndval1- for Sunday and Monday, and l-wkndval2- for only Sunday.

    what should I change in formula and how to indicate for different employees their timetable.
    Thank you in advance
    Natalia

    Reply

  • I really like the tracker. What if I add 6th type of leave? Can you help please

    Reply

    • Please do the following to add more leave types.

      1. Just type sixth leave type in SETTINGS sheet’s Leave type table.

      2. In the TEAM DASHBOARD sheet,
      a. Edit conditional formatting rules. You will see rules for the 5 colors.We need to create a similar rule. The formula for the sixth color is =C8=INDEX(L_LEAVE,6).
      Apply this to all the cells in the calendar.
      b. Insert a column between columns AM and AN. This new column is to calculate the sum for sixth leave type for each employee.
      c. In that new column, we need to enter formula. You can copy formula from cell AM8 and paste in AN8(newly created column). Then drag down the cell to row 37 to copy the formula for all employees.
      d. In the Total Leave column, edit the formula to sum all the 6 leave types (by default it was for 5 leave types).

      3. In the EMPLOYEE REPORT sheet,
      a. Edit conditional formatting rules. You will see rules for the 5 colors.We need to create a similar rule for the sixth color. Apply this to all the cells in the calendar.
      b. Insert a column between columns AN and AO. This new column is to calculate the sum for sixth leave type for each month.
      c. In that new column, we need to enter formula. You can copy formula from cell AN12 and paste in AO12 (newly created column). Then drag down the cell to row 23 to copy the formula for all months.
      d. In the Total Leave column, edit the formula to sum all the 6 leave types (by default it was for 5 leave types).

      These steps above should implement one additional leave type. You can repeat the same for more additional leave types as needed.
      Please try and let me know if there are any questions.
      Best wishes.

      Reply

  • Hi Indzara, i had used the Employee leave tracker, it is a very great excel and i am requiring it for my team,

    adding to which am i need to add on a few points : calculate the total leave balance available after all the leaves have been used, can you please help me on it,

    you can also contact me through divya.friendly1@gmail.com i will be very happy to be a part of all the queries which are required.

    Reply

  • If I want to add one or two pieces of information of the employee alongside his start date and termination date, say his staff number in the employee sheet, and bring them up to the employee attendance report the way the employee start date is done, how do I do it?

    Reply

    • You can create a new calculation and follow the approach I have used for the Employee start date. You can replace the reference to the Employee Start date with another field that you are pulling from Employees table.
      Best wishes.

      Reply

  • please i want you enplane the (=IFERROR(IF(J$7=””,”NA”,IF(J$70,J$7>INDEX(T_EMP[TERMINATION DATE],ROW($B12)-ROW($B$7))),”NE”,IF(NOT(ISERROR(MATCH(J$7,L_HOLS,0))),”H”,IF(INDEX(L_WKNDVAL,WEEKDAY(J$7,1))=1,”WKND”,INDEX(T_LEAVE[LEAVE TYPE],SUMPRODUCT(–(T_LEAVE[EMPLOYEE NAME]=$B12),–(T_LEAVE[START DATE]=J$7),ROW(T_LEAVE[LEAVE TYPE]))-ROW(T_LEAVE[#Headers]))))))),””)…by video to can i understand it…thank you

    Reply

    • J7 represents the date.
      If the date is blank, then NA
      If the date is > employee’s termination date, then NE (not employed)
      If the date is a holiday, then H
      If the date is a weekend day then WKND
      else display the leave type taken by employee on the date.

      Reply

  • how can i change all the data (team dashboard) when i change the month?

    Reply

    • When the month is changed, the data should change automatically. Please let me know if there are any questions. Best wishes.

      Reply

      • i know and i saw it in your sheet so i want know how you did it(can please explain all the equations in the sheet by video please?

        Reply

  • Like to echo all the compliments for an excellent design. Found this most useful. Just wondering how to amend this template for a 5 and a half day workweek. Sunday is not a workday, but Saturday is half a working day here. Vacation leave for Thursday to Monday say is therefore counted as 3.5 days and not 4 days as in the current template. Whilst a half day leave type could be interposed, this is not as elegant. Also, the day-count towards the specific leave type taken would have to be manually adjusted. If the template can be amended so Saturday would automatically be counted as half a day, that would be perfect. Thank you.

    Reply

    • Thanks for the feedback.
      I will consider this scenario in the next version of this template. It will take some development effort.
      Best wishes.

      Reply

  • Hello,

    This is amazing, I was just wondering if it was possible to have on of the leave types over ride a weekend. I want to use it keep track of employees who skip their scheduled weekend OT?

    Reply

    • Thank you. By default, if leave is taken on a weekend day, it doesn’t count as leave. I will look into making it flexible in the future. Thanks for feedback. Best wishes.

      Reply

  • If we wish to use sandwich rule, means in case Saturday and Monday both lies in vacation then how it can be achieve.

    Reply

    • Thanks for your feedback.
      The sandwich rule is not implemented here. It will require more complex logic to implement that, I think. I didn’t know that this rule existed before reading your comment and searching online. 🙂 Thanks for sharing.
      Best wishes.

      Reply

  • Hi,

    This is really great but i need is different days off for all employee, i buy Team vacation planner which is not all in i need was there.

    this is such more helpful if i can arrange all different days off for each employee

    Reply

    • Thanks for your comment.
      Can you please provide an example as I am not following your specific requirement? I have also emailed you. You can email a file with some sample data if possible.
      Thanks & Best wishes,

      Reply

  • Hello Indzar,

    I can’t seem to download the excel template onto my pc. Is iti possible to send it to me via email?

    Thank you.

    Reply

    • The links to files are available in this blog post. Please search for the word ‘Download’ to find the location. I will also email the file. Thanks. Best wishes.

      Reply

  • Hi,
    I have tried changing the color using the conditional formatting and it did change in ‘TEAM DASHBOARD’ sheet but though I did the same in sheet ‘EMPLOYEE REPORT’, the color didn’t change.
    Please help and thank you in advance.
    Again GREAT WORK!

    Reply

    • Please email the file to indzara at gmail and specify what changes you have made. I will review and get back to you. Thanks. Best wishes.

      Reply

  • hello, I am new to exel so my problem probably just relates to that. I have entered in the employee names and dates and entered in the leave time taken however it doesn’t show on the dashboard nor the spreadsheet. Any ideas what I have done wrong?

    Reply

    • Hello, I am new to exel so my problem probably just relates to that. I have entered in the employee names and dates and entered in the leave time taken however it doesn’t show on the dashboard nor the spreadsheet. Any ideas what I have done wrong?

      Reply

      • Please email the file to indzara at gmail. I will review and get back to you. Thanks. Best wishes.

        Reply

    • Please email the file to indzara at gmail. I will review and get back to you. Thanks. Best wishes.

      Reply

  • Hi! This is indeed a very useful template, a great piece of multiple combinations!

    I wanted to ask whether it is possible to include two Saturdays as working days in every month.

    Thanks!

    Reply

    • Thanks for the feedback.

      Enabling support for two specific Saturdays each month would require significant modification.
      You can enter those non-working Saturdays as holidays in Holidays table. This would take care of leave calculations and summary. The only downside is that those days will be shown as Holidays and not Weekends.
      Hope this helps.
      Best wishes.

      Reply

  • Hey – Thanks a lot for this template. I want to change the source to track attendance for employees by adding 2 new sheet in this excel file. the first one data for vacation with manager approval and second sheet for absent without manager’s approval. can u please help me with the formula ? Thanks in advance.

    Reply

    • You are welcome.

      This design change is significant and I am sorry that it is not easy to explain the formula here.

      I take customization projects for a fee. Please email me if interested. Thanks. Best wishes.

      Reply

  • Hi Again,
    Forgot to write it is of course in the sheet called “EMPLOYEE REPORT” I need another cycle. since our cycle is May-April I would need 2 years, in this case May 2017-April 2018.

    Reply

    • I have explained in the previous response how to change the months.
      The sheet takes year as Input and shows the results. Extending to multiple years would require some further modification which would become difficult to explain in text.

      I take customization projects for a fee. Please email me if interested. Thanks. Best wishes.

      Reply

  • Hi,
    Thanks a lot for this great template. I have a question, I am from Denmark so we have another cycle May-April. Is it possible to change easily so the cycle is not Januay-December but instead May-April.
    Hope you know what I mean 🙂

    Thanks

    Reply

    • You are very welcome.
      Changing the cycle requires a few steps.
      1. Unprotect the sheet
      3. In column B, where month names are, we have to edit the formulas. You can just type May 1, 2016 in cell B12, June 1, 2016 in cell B13 and so on.
      3. In column A, you will see numbers 1 to 12. Replaces them with 5 to 4.
      4. Protect the sheet again.

      Please try and let me know if there are any questions
      Best wishes.

      Reply

  • Hello!

    Thanks for the great template. Very usefull and handy.
    I’m wondering about one thing; is it possible to work with departments?
    I’ve added an extra column in the employees tab. In the settings tab i made it possible to define these departments. In team dashboard, i added an extra column next to my employees so i can filter. But i also would like to be able to use this like you do with employees in the employee report. There you can select an employee. I want to also be able (in a different sheet) to filter on departement and get the year overview and calculations for every member in this department.

    Best wishes!
    And thank you in advance for your feedback.

    Reply

    • You are welcome. I am glad that you find it useful.

      To enable filtering by department should be possible. It is hard to explain the formulas and approach here. But it should be possible. I take customization projects for a fee. Please email indzara@gmail.com with requirements if interested.

      Thanks & Best wishes.

      Reply

  • Hello. Thanks for your amazing work. would it be possible to have an overview of all employees yearly leave balance with-in one sheet?

    Reply

  • This is very helpful and just what I was looking for, but I do have 1 question. Is it possible track hours instead of day?

    Reply

    • Thank you.
      It is not designed to easily capture hours. We can tweak a few things to this template. When we define leave types, we can enter leave types for partial days. Assuming each day is 8 hours, create a leave type for 2 hours off (0.25 day) and 4 hours off (0.5 day). Then, in the Dashboard, we can edit the Total Leave column where we multiply the result by 8 to convert days to Hours.
      Best wishes.

      Reply

    • You are very welcome. Thanks for taking the time to provide feedback. Best wishes. 🙂

      Reply

  • Hello. Thanks for your amazing work. I want to add more than 5 types of leaves, is it possible to have 8 types of leaves?

    Reply

    • Please do the following to add more leave types.

      1. Just type sixth leave type in SETTINGS sheet’s Leave type table.

      2. In the TEAM DASHBOARD sheet,
      a. Edit conditional formatting rules. You will see rules for the 5 colors.We need to create a similar rule. The formula for the sixth color is =C8=INDEX(L_LEAVE,6).
      Apply this to all the cells in the calendar.
      b. Insert a column between columns AM and AN. This new column is to calculate the sum for sixth leave type for each employee.
      c. In that new column, we need to enter formula. You can copy formula from cell AM8 and paste in AN8(newly created column). Then drag down the cell to row 37 to copy the formula for all employees.
      d. In the Total Leave column, edit the formula to sum all the 6 leave types (by default it was for 5 leave types).

      3. In the EMPLOYEE REPORT sheet,
      a. Edit conditional formatting rules. You will see rules for the 5 colors.We need to create a similar rule for the sixth color. Apply this to all the cells in the calendar.
      b. Insert a column between columns AN and AO. This new column is to calculate the sum for sixth leave type for each month.
      c. In that new column, we need to enter formula. You can copy formula from cell AN12 and paste in AO12 (newly created column). Then drag down the cell to row 23 to copy the formula for all months.
      d. In the Total Leave column, edit the formula to sum all the 6 leave types (by default it was for 5 leave types).

      These steps above should implement one additional leave type. You can repeat the same for more additional leave types as needed.
      Please try and let me know if there are any questions.
      Best wishes.

      Reply

  • Thanks for your template !!! super helpful !
    btw, Can I calculate how many staff on vacation every day in Leave Tracker Dashboard?

    Reply

    • You are welcome. I am glad to hear that it is helpful.
      The days are represented from column C to column AG.
      For calculating number of staff on vacation every day, please write a formula using COUNTIF function.
      For example, count the number of appearances of ‘Vacation’ in column C from cell C8 to cell C37. Then, you can drag this formula to column AG.
      Thanks & Best wishes.

      Reply

  • It is the best template I have ever seen. Thanks a lot for sharing this. You are a Champ.

    Reply

  • Hi Team,
    If I need to add additional leaves apart from these, what will be the changes I need to make to the template.

    Reply

    • Please do the following to add more leave types.
      1. Just type sixth leave type in SETTINGS sheet’s Leave type table.
      2. In the TEAM DASHBOARD sheet,
      a. Edit conditional formatting rules. You will see rules for the 5 colors.We need to create a similar rule. The formula for the sixth color is =C8=INDEX(L_LEAVE,6).
      Apply this to all the cells in the calendar.
      b. Insert a column between columns AM and AN. This new column is to calculate the sum for sixth leave type for each employee.
      c. In that new column, we need to enter formula. You can copy formula from cell AM8 and paste in AN8(newly created column). Then drag down the cell to row 37 to copy the formula for all employees.
      d. In the Total Leave column, edit the formula to sum all the 6 leave types (by default it was for 5 leave types).

      3. In the EMPLOYEE REPORT sheet,
      a. Edit conditional formatting rules. You will see rules for the 5 colors.We need to create a similar rule for the sixth color. Apply this to all the cells in the calendar.
      b. Insert a column between columns AN and AO. This new column is to calculate the sum for sixth leave type for each month.
      c. In that new column, we need to enter formula. You can copy formula from cell AN12 and paste in AO12 (newly created column). Then drag down the cell to row 23 to copy the formula for all months.
      d. In the Total Leave column, edit the formula to sum all the 6 leave types (by default it was for 5 leave types).

      These steps above should implement one additional leave type. You can repeat the same for more additional leave types as needed.
      Please try and let me know if there are any questions.
      Best wishes.

      Reply

  • Hi first of all thats is an amazing work
    but i have a question dose anyone knows how to make a graf out of all the employees. for example in January 10 called sick feb. 3 called sick ect. and if so can it also be done on a weekly basis.

    Reply

    • Thank you.
      You can write a formula using Countif function in the Team_Dashboard sheet. In row 38 or below, you can write that as each column represents a date. For example, if a leave type is ‘Sick’, to count Sick days count occurrences of ‘Sick’ in that column.
      Weekly would require some more logic in formula and would be hard to explain in text in this comments.
      Best wishes.

      Reply

  • By the way, when I mentioned “Added” which mean I inserted the Microsoft Date and Time Picker control onto “Leave” worksheet and link it’s properties to the leave date cells ( Start Date and End Date ).

    It populated those two cells with the dates that I selected from the control that I just added but it did not reflect into the “Team Dashboard” as well as “Employee Report.”.

    Reply

    • I have not worked with the date picker. Since we need to enter dates in many cells, it might be an overload and slow the file, if we create so many date pickers. Sorry.

      Reply

  • Thanks Indzara, your template is very helpful.
    It would be great if you could add Calendar control or Date Picker to fill in dates for “Enter Leave Data”.
    So that we can simply click and choose the start date and end date for the leave type.

    I have added the Calendar control but somehow it did not work.

    Thanks
    -Sazali-

    Reply

    • I have responded to your other comment about this. I am glad to hear that it is useful. Thanks. Best wishes.

      Reply

  • The template is great, thx. However, when i input year 2017 in Sheet “Employee Report”, i directly get NA for all fields.

    Reply

    • The template uses an End Date (set to Today) logic for the Employee report. This is to ensure that the report, by default, shows only employee attendance/vacation as of today. If you enter 2017 in Year, but End Date is set to ‘Today’ (Today is Dec 5, 2016). The 2017 calendar year is after the End Date and thus ‘Not Applicable’ (NA). Please change the End Date or the Year. It should work then.
      Please let me know if this does not address your question. Thanks & Best wishes.

      Reply

  • The template is very usefull. I would only wish for one improvement. Since I have a global Team the Holidays are quite different for several Team members. So it would be great if I could assign certain Holidays to certain employees. Is there any possibility for that?

    Reply

    • Thanks for the feedback. Having different holidays for different employees would require some development. I take such customization projects for a fee. If interested, please email at indzara at gmail. Thanks.

      Reply

Leave a Reply

Your email address will not be published. Required fields are marked *