I need a template for Employee annual leave tracking

[aMADeO!]

I need a template for Employee annual leave tracking template. I tried to find out some templates and ready to use samples but nothing is working. Can anyone please help.

[BillieJ]

I have a short formula which I think can help you out. Or else just click on the attachment and check the file.

• Cell A1: Name
• Cell B1: Start Date
• Cell C1: End Date

[Shurod]

Excel has many functions, modules and other assistants whose goal and to facilitate the creation and layout of tables. I can provide you a sample for the same.

• In the first cell A1: Enter the Holidays for the Year
• In the Second cell A2: Add the Full Name
• Now in A3: Add the name of X people to manage
• Afterwards move to other column and in B1 add the date in formation of dd/mm/yyyy. You can set the Format by Right click > Format > Cells > Number > Custom > Type.
• In B2 add = B1. This will copy the date from above.
• Now add both the row by draging or adding =B1:B2. You can also use AutoFill to Fill Series.
• Select the entire sheet and activate the Conditional Formatting with Cell Value = "c" and police Format dark blue + light blue fill pattern If necessary, enter the legend end of the table: c: day off.