Cite.Co is a repository of information and resources created by industry seniors and experts sharing their real world insights. Join Network
Hi Rohit
Please make following changes. Unprotect the sheets,password is "shiv".
Now let say if you want to change weekly off from Saturday to Friday in Jan, just copy cell G5:G34 and paste in F5:F34 and again copy data from I5:I34 and paste it to G5:G34. This will change your first weekly off. Similarly do it for all weekoff's in all months.
You can change ML (A11) to CL and change description as Casual Leave instead of Mandatory Leave. Same will be updated in all the sheets automatically.
Please try and let me know.
It will not be possible for me to work on individual request at this point of time as I am kinda busy now a days.

From India, Visakhapatnam

Why do I always receive the following whenever I open tried to open the file:
You can only download ONE file in TWO minutes. Please wait for 2 mins for your next turn to download.
The System Will Automatically Retry In 60 Seconds. You can retry yourself by clicking here
By the Shiv,could email to me the leave record tracker to

From Singapore, Singapore
Friends I have already shared password for same. It is "shiv". I am trying to attach another unprotected copy, while not able to. Will attach it soon? Regards, Shiv
From India, Visakhapatnam
HI Rohit, Please find attached leave record format. It might Help. Regards Vipin
From India, New Delhi

Attached Files
File Type: xls leave record format.xls (50.5 KB, 920 views)

Mr Shiv.. I can easily make out that u work for my company. Please delete all the links relating to the company. It will be an audit issue considering the department u r working for.
From India, Hyderabad
Hi Buddy
Thanks allot. Even I thought of same after uploading the template, while then I realised that all links are intranet links and will not work in internet and will not be an audit issue. But still now I have removed the template and will upload new one.
Thanks & Regards,

From India, Visakhapatnam
Hello Friends Based on many of the users request I am attaching a new unprotected version of Leave Tracker. Regards, Shiv
From India, Visakhapatnam

Attached Files
File Type: xls Leave Tracker_New_Unprotected.xls (1.89 MB, 1005 views)

Excellent contribution Shiv would be appreciate if u give some guidance how to use this Lovely format......... seeking urs guidance Rekha
From India, Delhi
Hi Rekha
Few points that you need to keep in mond while using the tracker are :
1) Update only white cells.
2) Use the master tab to update details of all individuals in your team during the year. Keep on updating same on regular basis
3) Update blank holidays according to your organisation. This is used all the sheets to calculate net working days.
4) Update taff name in Jan.
5) Let say in Jan end someone has resigned you can use R code for same. In Feb you can replace that individual with new one, select from drop down (as you are updating list of all team members in master sheet)
6) I have considered two days as weekly off's. You can just move it to any other day.
This tracker is very simple to use and understand. Let me know,in case you have specific questions egarding same.
Thanks & Regards,

From India, Visakhapatnam
hello Dhanesh,
I went through your leave record format,its really gud, but I have a query. Is it only for single user or can be used for multiple users. I tried to use it bt every time it over write the single user. I am a bit confused, because if it is for single user then in sheet 2( Leave balance) why u have mention no. of rows for multiple users?
Please guide me so that i can use it in my Organization..

From India, Ludhiana

This discussion thread is closed. If you want to continue this discussion or have a follow up question, please post it on the network.
Add the url of this thread if you want to cite this discussion.

About Us Advertise Contact Us
Privacy Policy Disclaimer Terms Of Service

All rights reserved @ 2020 Cite.Co™