2025 Leave Tracker & Vacation Tracker Google Sheet Template
Whether you’re an HR Manager, a Small Business Owner, or a Project Manager, efficient employee leave/vacation tracking is crucial. Our meticulously crafted Google Sheet Template simplifies this task, offering a well-organized solution for monitoring leave/vacation.
With this simple Google Sheet Template, gain access to a user-friendly calendar view that conveniently displays leave data for multiple employees. Additionally, it generates comprehensive annual employee reports for your convenience.
This template is designed for Google sheets, but if you are looking for an Excel template, please visit Employee Vacation Tracker
Benefits of the template
- Customize settings to meet your business needs
- Track 5 types of employee leave
- 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 (example: 4 days of leave from Nov 21st to Nov 24th)
- 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
Free Download
Please check our premium Leave Manager in Google Sheets with additional features.
How to Use Employee Leave vacation tracker in Google Sheets
- Configure the Settings information
- Input Employee Data, Leave Information
- View reports on Team Dashboard and Employee Report
Before you begin to enter data, ensure to make a copy of the template in your Google Drive folder. Follow this article to achieve the same.
Step 1: Configure the Settings information
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.
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’.
In order to calculate attendance of employees automatically, we need to know company weekends so that we can remove them from working days. Select the same as weekends in the Settings as shown:
Step 2: Enter Input Details
Enter company holidays
Enter list of holidays in your company.
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.
Enter Employees data
Now, we move to the Employees sheet.
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 google sheets vacation tracker 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.
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.
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.
Please note that for error free data entry, the Leave sheet has data validations on the Employee Name and Leave Type columns. We are done with data entry. It’s time to see the template’ magic in creating the vacation calendar and report.
Step 3: View Reports
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.
As you can see from the above screenshot, the leave types are shown in different color.
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).
Not Applicable represents the days that are not actual dates. For example, if you choose November month, 31st day will be Not applicable. For February in a non-leap year, 29, 30, 31 will be Not Applicable days.
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.
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 represents the number of days an employee worked or is scheduled to work.
Worked Days is calculated as (Company Working days – Holidays – Weekends – Not Employed Days – Total Leave days)
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.
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: Year, Employee name and Starting Month of the report needs to be entered. The template automatically calculates the report end date based on whether the employee has left the organization or not.
That is, if the employee has left the organization any day after the starting month, the termination date shall be displayed as End date or the end date of the current report is displayed as End date.
This sheet has 2 pages as well. First, the calendar view.
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.
This is one of the best employee vacation tracker google sheets for you. For any queries or customizations, please reach out to us at support@indzara.com
Recommended Templates
Try our premium Leave Manager in Google Sheets with additional features.
-
Product on sale
Employee Leave Manager Google Sheet TemplateOriginal price was: $50.$40Current price is: $40.
135 Comments
When scaling this template to support larger teams or adding a variety of custom leave types like compensatory time off, do the background native arrays automatically expand their lookups, or is it better to manually adjust the named ranges to prevent formula breakdown?
Thank you for your question!
Named Ranges — Manual Adjustment Required
When scaling the template to accommodate a larger team, the named ranges do not expand automatically. You will need to manually adjust them to include the additional rows.
Adding Custom Leave Types
If you need to add leave types beyond the default limit, manual updates will be required across three areas:
Named ranges
Relevant formulas
Conditional formatting rules
Recommended Upgrade
For a more scalable solution, our Employee Leave Manager – Google Sheet Template may be a better fit. It includes:
Support for a greater number of leave types
Leave entitlement tracking
Dynamic arrays that automatically expand as you add employees and leave entries
Feel free to raise a support ticket if you have any further questions — we’d be happy to help!
If I want certain employees to have saturdays as weekend and some weekday (meaning they are required to work on this day), how can I change in the employee report and team dashboard?
Thank you for your interest in our template and for your question about assigning different weekend days to specific employees.
We can support dynamic weekend settings by:
* Adding seven columns in the Employee table to capture each employee’s weekend selection (one column per weekday).
* Updating the weekend logic in the Employee Report and the Monthly Dashboard calendar formulas to reference these selections.
This would be handled as a customization project for a fee. If you’d like to proceed, please write to us at the below link for estimation:
https://support.indzara.com/support/tickets/new
Best wishes.
Is there a limit to how many employees you can have? I try to copy and paste down on the Team Dashboard Sheet and it will not go past a certain line even though I have more employees listed on my Employee Sheet.
Thank you for your interest in our template!
By default, the Monthly Team Calendar supports up to 30 employees. However, you can easily extend this by duplicating the formulas from the last row:
1. Select the last row with formulas, then drag the fill handle (small green square) down to add more rows.
2. Alternatively, select the last row along with blank rows below it and press Ctrl + D to copy the formulas and formatting.
Best wishes.
I have tried to copy and drag down but it will not allow the names to continue past the 30. The formulas are being carried down into the cells but nothing is transferring over. I am not sure what is wrong.
Thank you for your message, and we apologize for the inconvenience caused.
We understand that you’re having trouble extending the list of employee names beyond 30 rows. We tested the steps on our end in the Leave Tracker Google Sheets version, and the formulas are working as expected when duplicated correctly.
To help you further and resolve the issue quickly, please share a link to your copy of the file by submitting a support request at the following link:
Submit a Support Ticket
Once we receive your file, we’ll be able to investigate and guide you more precisely.
Looking forward to assisting you!
Hello! Thank you SO much for this template; is there a way to change the name of the different items tracked; my office would need vacation, offsites, and leave instead of the regular options. I see the edit ability as locked for the drop down menus
You are welcome. Thank you for showing interest in our template.
Yes, you can change the options in the settings page on cell E5 to E9.
Best wishes.
This is awesome, how can I tweak this so if employee’s leave overlaps with a holiday or a weekend, it DOES count as a leave day?
So if they take a sick day on a weekend the sick day color would show instead of the weekend color ?
Thank you for sharing your valuable feedback.
To solve your requirement, you will need to unprotect the Team Dashboard and Employee Report using the password indzara. In the formula used inside the calendar, you need to swap the Holiday and Weekend condition after checking for applied leave.
We take customization projects for a fee. If you want us to process the customization from our end, please write to us at the below link for estimation:
https://support.indzara.com/support/tickets/new
Best wishes.
Is your template able to process 2 events in 1 day? For eg. an employee applies for half medical leave and half annual leave for the same day.
Thank you for showing interest in our template.
Currently, the requested feature is possible in our premium version of the template but our free version of the template does not have the requested feature. Following is the link to the premium version of the template for quick reference:
https://indzara.com/product/hr-templates/employee-leave-tracker-excel-template/
Best wishes.
Hi, the template is great! However, it would be really useful if you could add a column with a calculation to show days remaining? I have added a column in the employee sheet which states total days entitlment, however when I input a simple formula to calculate the days using the employee report sheet it automatically recalculates when I select a different member of staff. Just wondered if there was a way around this as I am not very familiar with sheets or formulas? Many thanks!
Thank you for using our template and sharing your valuable feedback.
We have the requested entitlement setup feature available in our premium version of the template. Following is the link to the template for quick reference:
https://indzara.com/product/hr-templates/employee-leave-manager-google-sheet-template
Best wishes.
Hello, I recently took this report over from a colleague who left so I am unfamiliar with fixing it.
We use the leave, team dashboard, and employee tabs, but when employees input their leave on the leave tab it has stopped updating it in the reports. Any advice on how to troubleshoot and get these reports to update again?
Thank you for using our template. We regret the inconvenience caused.
Please share your copy of the template with sample data having the highlighted issue to us at the below link to check further:
https://support.indzara.com/support/tickets/new
However, the simplest fix is by downloading a fresh copy of the template and move your data to the new copy of the template.
Best wishes.
Is there a way to change the years to a fiscal year instead of a calendar year?
Thank you for showing interest in our template.
The requested feature is available in our premium version of the template.
Following is the link to the template for quick reference.
https://indzara.com/product/hr-excel-templates/employee-leave-manager-google-sheet-template/
Best wishes.
This template is wonderful, thank you. Is there a way of entering non-working days for part-time staff, please?
Thank you for sharing your valuable feedback. You are welcome.
Yes, we can move the weekend selection to employee sheet to select different weekends for each employee and modify the formulas to calculate the weekends from the employee table.
We take customization project for a fee. Write to us at the below link for estimation:
https://support.indzara.com/support/tickets/new
Best wishes.
Hi, is there a way to change one of the leave types to an ‘overtime’ type where it adds a day rather than takes it away? Thank you!
Thank you for showing interest in our template.
Currently, overtime is not supported in our template. Our premium version of the template will allow you to entered as negative day value if an employee is working on a holiday or a weekend. Let’s call it a ‘Make up Day’.
Following is the link to the premium version of the template for your reference:
https://indzara.com/product/hr-excel-templates/employee-leave-manager-google-sheet-template/
Best wishes.
Hello, each employee has its own weekends off, how can we change it instead of a company weekend since per employee has its own weekend?
Thank you for showing interest in our template.
We can more the week end setup to employee table with 7 additional columns for each employee to choose their week ends. Then we can modify the formulas to calculate the weekend from employee table. We take it as a customization project for a fee. Please write to us at the below link for estimation:
https://support.indzara.com/support/tickets/new
Best wishes.
Best wishes.
hello sir, excellant work!!! Do you have Purchase management templete
Thank you for showing interest in our template and sharing your valuable feedback.
If you want to track inventory, please check our template at the below link:
https://indzara.com/free-excel-template-for-retail-inventory-management-template/
If you want to track inventory along with the cost calculations, please check the template at the below link:
https://indzara.com/product/inventory-management-excel-templates/retail-business-manager-excel-template/
Best wishes.
Hello! Thanks for putting this all together – this is very helpful! Is there a way to change the color for “Vacation” all throughout the spreadsheet?
We are glad that our template is helpful.
The color of the leave type has to be manually changed in each location. For employee report calendar and Team dashboard calendar, you need to select a cell inside the calendar and change the color in conditional formatting.
Best wishes.
Hi, this is very useful. Can you add drop down category for location (site office) of employee aside from year and month selection? thanks a lot.
We are glad that it was useful.
The requested feature is available in our premium version of the template. Following is the link to the same for your quick reference:
https://indzara.com/product/hr-excel-templates/employee-leave-manager-google-sheet-template/
Best wishes.
how I can do the yearly summary for this sheet?
Thank you for showing interest in our template.
Currently, the year summary is available only on our premium version of the template. Following is the link to the template for quick reference:
https://indzara.com/product/hr-excel-templates/employee-leave-tracker-excel-template/
Best wishes.
Hi, great template!
I was wondering If there is a way to have repetitive dates. Some people work part-time on a fixed schedule. I’d like to be able to show that they are never there on Monday, for instance.
At the moment, I’d have to add one leave per week for this, which is a bit cumbersome.
Thank you for showing interest in our template.
If you referring to rotational week-off, you need to have all day as working days in settings and Week-off as leave type to apply rotational week-off in leaves.
We take customization projects for a fee. You can write to us at the below link for estimation:
https://support.indzara.com/support/tickets/new
Best wishes.
How do we add more than 30 employees? I can’t seem to get the data to pull through on to the team dashboard for additional employees added
Thank you for showing interest in our template.
You will need to expand the number of rows for the employee name’s named range.
Best wishes.
I tried to add in employee names but it doesn’t show under Team Dashboard sheet. Hope you can help me on this.
Thank you for showing interest in our template.
The template is limited to 30 employees by default. You need to goto Data Ribbon on top -> Named Ranges. Then need to change the rows to more rows.
You can also purchase our premium version of the template to have option to enter more employees. Following is the link to the template for quick reference:
https://indzara.com/product/employee-leave-manager-google-sheet-template/
Best wishes.
How can we add an additional leave type?
Thank you for showing interest in our template.
You will need to duplicate conditional formatting and modify some formulas. For additional leave types, you can also purchase our Premium version of the template at the below link:
https://indzara.com/product/employee-leave-manager/
Best wishes.
Hello,
Is there a way to remove the Termination Date tracker and repurpose it?
Thank you for showing interest in our template.
Removing the termination date involves changing the formulas in calendars. Instead you can hide the termination date column and add a new column as per your requirement at the end of the table.
Best wishes.
Hello,
Is there an easy way to delete “types of leave” categories or the colors associated with the types of leave? I can edit it on a single page but it does not carry over onto the other pages. Thanks!
Thank you for showing interest in our template.
There are two possible ways:
1. The simpler solution is, you can enter not applicable in settings sheet and delete leave type legend for team dashboard and employee report.
2. Delete the leave type legend and conditional formatting of the colours that are not required in team dashboard and employee report. Select any cell inside the calendar of team and employee dashboard and goto Format ribbon -> Conditional Formatting.
However, you will have to do it separately in leave dashboard and employee report.
Best wishes.
Hi,
Would it be possible to have 2 holiday dates options? I have employees who work in 2 different countries having different PH.
Thank you for showing interest in our template.
Yes, it is possible to have another list of holidays and add a column in employee table to choose the employee’s location. Then we can modify the formula to pick the holiday list according to the employee’s location.
We take customization projects for a fee. Write to us at the below link for estimation:
https://support.indzara.com/support/tickets/new
Best wishes.
can you still use this if you are tracking using the employees anniversary date?
Oct 14 22-oct 14-23?
Thank you for showing interest in our template.
The employee report is fixed to display for the period Jan to Dec. If you want work anniversary PTO setup, please check our PTO manager template at the below link:
https://indzara.com/product/small-business-paid-time-off-manager/
But currently the same is not available in Google Sheet version.
Best wishes.
Thank you so much for this! It saves me a lot of time.
Although, I encountered a problem and I hope you can assist me with this. When I change the month, the exiting leaves are reflected in the changed month as well.
Hoping for your response!
You are welcome.
It could happen only when the formulas are converted as values. Can you try moving your data to a fresh copy of the template.
If you are still facing the issue, please share your sheet support@indzara.com with edit access to check further. Ensure the Notify People is select along with the notes added in the message.
Best wishes.
Is there a way I can share this with my team so that they can access their PTO from the Employee Report tab – without giving them permission to edit the document?
Thank you for using our template.
Yes, you can upload the template to Microsoft OneDrive and use Excel online to share to your template members with view access.
Best wishes.
Hi, excellent work! What can I do if each employee has different weekend/rest days? Thanks alot!
Thank you for showing interest in our template and sharing your valuable feedback.
You will need to move the weekend selection for each row of the employee table and modify the formulas to check for the weekend from the employee table. We take customization projects for a fee, you can write to us at the below link for estimation:
https://support.indzara.com/support/tickets/new
Best wishes.
Absolutly perfect … just the template I needed … I really realy “wins” a lot of time instead of starting a new GSheet from scratch …
Thank you for sharing your valuable feedback.
Best wishes.
Thank you for a wonderful application! I manage a small company and finding this template has saved me many hours of trying to put something ugly together myself. The only question I have is can you change the label colors? For example, I only need to track vacations and the grey color doesn’t attract attention easily. Thank you again for a great tool!
You are welcome. Glad that the template is helpful.
Yes, you can change the colors by modifying the conditional formatting rules.
If you need any assistance, please email your requirements to support@indzara.com
We will do our best to help.
Thanks & Best wishes.
Thank you for the hint – I was able to figure it out!
Hey,
Thank you for your sheet, it’s really beneficial.
Was asking how can I override the hierarchy of leaves, vacations, holidays, etc.. in a certain case?
Do I have to enter the leave data for each time I need to track sick or vacation? For instance I have some one sick on 1/24/2022 then took vacation 2/21-2/24.Do I need to put there name in 2x’s with the dates listed? So on line B4 & B5?
Thank you for showing interest in our template.
Yes, you are correct. You need to enter leave for 24th Jan on one row with start and end date as 01-24-2022 and another row with start date as 02-21-2022 and end date as 02-24-2022 with same employee name.
Best wishes.
Is there a way to have the vacation information imported into Google Calendar?
Thank you for showing interest in our template.
Currently, the requested feature is not available in our template.
Best wishes.
Hello, wonderful work you’ve done.
I added some more leave types, how do I get the leave type colour to reflect on the team dashboard?
Thank you for using our template.
Adding additional leave types involves some complex steps. We take customization project for additional fee. You can write to support@indzara.com for estimation.
Currently, we have a Excel template with more leave types, you can check the same at the below link but it is not yet available in Google Sheet version:
https://indzara.com/product/employee-leave-manager/
Best wishes.
How many employees can be added?
Thank you for showing interest in our template.
By default the template is limited to 30 employees but you can write to support@indzara.com to get the procedure to expand the same.
Best wishes.
Bonjour,
je vous remercie pour ce modele gratuit.
Comment faire pour supprimer les types de vacances et ne laissez qu’un seul?
Thank you for showing interest in our template.
If you want only one leave type, you can delete the other leave types in settings tab. If this is not your concern, requesting to share some screenshot highlighting your concern to support@indzara.com to check further.
Best wishes.
Hello, I currently use this template and it has been working perfectly although, there are two employees which appear in the employee attendance as unemployed or color purple. I would appreciate if someone could give me a hand as I already checked and the start date for the employees is correct.
Thank you for using our template.
Requesting to write to support@indzara.com and your sheet link with view access to check further.
Best wishes.
Hi Indzara,
How can I add more types of leave?
Thank you for showing interest in our template.
Adding more leave types involves multiple steps, you can learn how to create the Excel version of the template at the below link to create additional leave type in Google Sheet. Formulas are similar in Google Sheet and Excel sheet.
https://courses.indzara.com/p/vacation-attendance-tracker-dashboard-in-microsoft-excel
You can also purchase our Premium version of the template to get more leave types. Following is the link to the template:
https://indzara.com/product/employee-leave-manager/
Best wishes.
First, thank you for providing this amazing template. It is exactly what I needed and I have been able to add more leave types to suit my needs. I need to have two holiday sections, one for Canadian Holidays and one for American holidays. I created a second Holiday table on the settings tab but am stumped with how to modify the formula on the Team Dashboard tab. I will leave H for the Canadian Holidays and I want to use A for the American Holidays. Where do I modify the formula?
Thank you for sharing your valuable feedback.
You can use the same formula used for the validating the H by naming the range of the American Holiday like L_AMR_HOLS as highlighted below. Ensure extra close brace is added:0,C$7>INDEX(TERMINATION_DATE,ROW($B8)-ROW($B$7))),”NE”,
=IFERROR(IF(C$7=””,”NA”,
IF(C$7
IF(NOT(ISERROR(MATCH(C$7,L_HOLS,0))),”H”,
IF(NOT(ISERROR(MATCH(C$7,L_AMR_HOLS,0))),”A”,
IF(INDEX(L_WKNDVAL,WEEKDAY(C$7,1))=1,”WKND”,
INDEX(T_LEAVE_TYPES,SUMPRODUCT(–(T_LEAVE_EMPLOYEE_NAME=$B8),–(T_LEAVE_START_DATE<=C$7),--(T_LEAVE_END_DATE>=C$7),ROW(T_LEAVE_TYPES))-3))))))),””)
Best wishes.
Hi can you drop the formula you use to add more leave type? I just need 1 more leave type. Thank you in advance!
Thank you very much Indzara for this project! More power.
Hi,
The sheet is great, but I’m not seeing the info entered in Team Dashboard translating over to the Employee Report tab…no entered time off is showing on this tab. What am I missing?
Thank you for showing interest in our template.
Requesting to share your sheet or screenshot of input and the concern report to support@indzara.com to check further.
Best wishes.
Hi,
This spread sheet is missing Dec 31 2021 date. How can I add the December 31 column?
Thanks
Thank you for showing interest in our template.
I have checked the sheet and the December 31 2021 is displayed on Team Dashboard in our end. Hence requesting to share your sheet to support@indzara.com to check further. If you are referring to Employee Report, requesting check whether cell B8 contains the end date as 31-Dec-2021 to view the employee report till the entered end date.
Best wishes.
Hey there indzara,
I have tried using your Leave tracker template and am impressed by it.
I have a query that would like answered:
In the settings sheet there is a row dedicated for “holidays” and I would like to create a similar row with a different title for different usage such as “Recess Week”. Is it possible?
Looking forward to your reply,
Regards,
Glendon
Thank you for showing interest in our template.
Yes, you can create a new table to list the recess week holiday days and following are the next steps involved. (Required medium skill on Excel formulas)
1. Unprotect the employee tab and team dashboard tab.
2. Replicate the formula used to highlight the holiday in employee & team dashboard tab and change the table to recess week holiday table. (Ensure open and close braces are correctly done)
3. Replicate the conditional formatting used to highlight holiday and change the table referring to holiday as recess week holiday and choose the preferred colour.
You can also write to support@indzara.com for processing the above modifications with a customization fee.
Best wishes.
Hi, Since im using google sheet can i know exactly how do i change the colour of vacation?
also can i add more holidays in your holiday column?
Thank you for showing interest in our template.
You can right-click anywhere inside the calendar and select conditional formatting to view the list of conditional formatting used to highlight the leave. You can then click the same and change the color.
Regarding holiday,
You can enter the list of holidays one after another. Currently the holiday is limited around 1000 and it will be more than enough for a year.
Best wishes.
Hi
My working week is Monday-Friday. I have had employee who worked overtime on the weekend which I recorded in the leave tab however because Saturday and Sundays are not work days – the overtime is not being recorded.
Is there a way around this?
Thank you
Thank you for using our template.
You can swap the condition inside the formula to check for Weekend after applied holiday/overtime to solve your requirement. We take customization project for additional fee, requesting to write to support@indzara.com for estimation of this customization.
Best wishes.
Hi Indzara,
How to check the remaining days of the leave?
Currently leave balance tracking is not available in our leave tracker Google Sheet template but it is available in our Employee Leave Manager Excel template. Following is the link to the template:
https://indzara.com/product/employee-leave-manager/
Best wishes.
hey, is there way i can change colours on vacation to different colour?
Thank you for showing interest in our template.
Yes, click any cell inside the calendar and goto Home -> Conditional Formatting -> Manage Rule. You can edit the rules to change the color of the leave accordingly.
Best wishes.
Hi,
This is a great sheet; thank you for sharing it!
There is one error that is happening to me that I can’t seem to figure out; I’d love your feedback.
I have entered all my employee’s information on the “employee tab.” However, when I view the “Team Dashboard,” it has employee 3 as having a recurring vacation day on the 15th of every month. Is there a way to clear that? I have not entered any data for Employee 3 on the “Leave tab.”
Many thanks,
Thank you for sharing your valuable feedback and highlighting the issue.
The default color of the cell is incorrectly set, requesting to click the cell and change the default color as white to resolve your concern.
Best wishes.
Issue:- After employee termination date, it still count working days inside Employee Report
We regret the inconvenience caused.
I am unable to replicate the issue.
Requesting to share your sheet to support@indzara.com to check further.
Best wishes.
Hi!
Thank you for creating this fantastic template. On the ‘Employee Report’ tab, is there a way to change the calendar to run July to June instead of January-December?
Thanks!
Thank you for sharing your valuable feedback.
Yes, it is will take 1 to 2 hours to process the customization and we process customization for a fee. Requesting to contact support@indzara.com for estimation.
Best wishes.
Thank you for this!
What if you only have two types of leave you want to track? We just have PTO so I figured I would track PTO and then a half-day option. However, every time I delete the other three, it changes the cell color of the days with no leave input from white to a color of one of the three leave options I am not using.
Thank you for using our template.
I am unable to replicate the issue, hence requesting to share some screenshot of your settings, Employee input, vacation input and click the concern cell in Team Dashboard and Employee report and take screenshot of formula bar along with the selected cell to support@indzara.com to check further.
Best wishes.
After filling in the data for July 2021 when I go to August 2021 and try to fill in, the data for July also changes. Basically all the months are showing same data. Please help resolve this. Thanks.
I have tested the sheet again but I am unable to replicate the highlighted issue.
Requesting to try making a fresh copy of the template. If you are still facing the issue, requesting to share the screenshot to support@indzara.com to check further.
Best wishes.
We love this template and it’s been very useful for us. Do you have any suggestions for how we can give employees live access to only their own summary information? Using importrange in another google sheet doesn’t bring in the formatting.
Thank you for sharing your valuable feedback.
The requested feature is currently not available.
Best wishes.
Hi!
Is it possible to change the color of the Vacation block?
Thank you! 🙂
Thank you for showing interest in our template.
Yes, you can change the colour by right-clicking anywhere inside the calendar and select conditional formatting to open the conditional formatting panel to change the colour.
Best wishes.
Hi.
Thank you for your template. I am really loving it.
But there is one option that I can’t find in it.
In my country, sometimes on a particular month, we have a Saturday or a Sunday as an official workday.
Is it possible to somehow mark these particular weekend days as workdays?
Thank you for sharing your valuable feedback.
Yes, it is possible and this can be taken as customization project for additional fee. Requesting to send an email to support@indzara.com for estimation.
Best wishes.
Hello,
this is a great sheet!
I have one question, is there any solution for in the case that one employee works only on the days of the weekend of other employees?
cheers
or in other words is it possible to make an EMPLOYEE LEAVE TRACKER sheet for each employee in some way to put in his weekends and holidays?
Thank you
Thank you for sharing your valuable feedback.
Requesting to check our Team Vacation Planner template at the below link, which has the requested feature of different weekend entitlement for each employee.
https://indzara.com/product/team-vacation-planner-excel-template/
Best wishes.
Hi!
How would I add more holiday dates?
Thank you for showing interest in our template.
You can add more number of holidays one below another. If you face any difficulty, requesting share some screenshot of your concern to support@indzara.com to check further.
Best wishes.
Thank you for this template. It’s just what I was looking for!
On employee 3, day 15 is always showing filled in with a vacation day, unless of course it’s a weekend.
It is not being counted as a vacation day, but the cell is filled in with that color.
Is there a way to fix this?
Thanks
Thank you for using our template and you are welcome.
We regret the inconvenience caused. Requesting to share the template to support@indzara.com highlighting the above mentioned issue to check further.
Best wishes.
hi there,
thank you so much for this awesome leave tracker. I was wondering how I could go about changing the number of days to hours in the settings section. we track all of our leave by hours. thank you so much
Thank you for sharing your valuable feedback.
You can enter the hours in settings instead of days and then in employee and team dashboard, multiply the working days formula with number of working hours for each day. For example if working hours is 8 hours a day multiply the formula with *8 at the end.
Best wishes.
Can you add more than 30 employees?
Thank you for using our template.
Yes, we can take it as customization project to add more than 30 employees. Requesting to contact support@indzara.com for an estimation.
Best wishes.
Hi,
If any weekend work team worked, how tracker will track tee same?
Thank you for using our template.
This can be taken as customization project for a fee by adding an another leave type, which can be used to add the working days. Requesting to contact support@indzara.com for an estimation.
Best wishes.
Can the template support more than 30 workes?. If can how to add the workers because when I added the 31 worker, it does not appear in team dashboard, leave and employee report.
Thank you for using our template.
You will get an email from support@indzara.com regarding the limit extension.
Best wishes.
As mentioned in one of the comments, changing the name of leave in the settings sheet and then applying a leave choosing that leave name does not add the color. It instead shows the name of the leave in the Team Dashboard sheet.
For ex:
I changed the name of leave from Vacation to Casual and then created a leave for an employee and chose Casual as leave type. However, the team dashboard shows Vacation text instead of showing the Black colour.
Any advise here. Thanks!
We are unable to replicate the issue from our end. Hence, requesting to share your sheet with some sample data and screenshots highlighting your concern to our support team at support@indzara.com to check further.
Best wishes.
Hi,
There was a mistake in my earlier query. Let me rephrase
leave type = Vacation
leave background cell colour in team dashboard = Black
1. I changed the name of leave from Vacation to Casual in the Settings page.
2. I then created a leave for an employee and chose Casual as leave type.
However, the team dashboard shows ‘Casual’ text instead of showing the Black color for the Employee.
I would want the cell to show the Black Color rather than the text.
Hope this is clear.
Thank you for sharing the details. You will receive an email from our support team shortly.
Best wishes.
Hi!
Absolutely love the template, thanks for creating it!
I think there might be some troubles with the “leave” tab. After a few entries (4 or so) of the same employee, the days won’t update in the “TEAM DASHBOARD” tab. Is there a need to adjust the formulas if there are multiple entries of the same employee?
Thank you for using our template and you are welcome.
We regret the inconvenience caused due to the highlighted concern.
Regarding more than 4 leaves for same employee, I have tried entering 5 same type leaves and different type leaves for same employee but unable to replicate the highlighted error. Requesting to share some screenshot to our support team at support@indzara.com to check further on your concern.
Best wishes.
Thanks for this great resource! On the “Employee Report” tab, is there a way to see an employees vacation days, etc for the entire calendar year, and not just through Today’s date? Would that require significant formula manipulation?
How do I change the colours of the different leave types? Also, when I change the leave type name to something else, it removes the color settings in the calendar view and just displays the name of the leave type?
Hello
Colors are changed in Conditional formatting rules. When leave type name is changed, the input data (leave data) also have to be updated with new leave types. If any questions, please email file to support@indzara.com
Thanks
Thank you for this! This is awesome.. more google sheets templates please!!
Thanks for your message.
The list of templates compatible wit Google sheets are at https://indzara.com/free-google-sheet-templates/
Best wishes