Leave Record For Small Organisations - XLS Download

hi Deepu,
I know this is probably an old post, but Im at a new job and I need some help as a part of my duties I have to handle HR and keep records of Leave days. Im not great with excel and im from east africa so leave days and sick leave and other leave is not the same as india.
Is there anyway you can help me?

Dear Mr. Deepu..

Hi...this is John here. Kindly provide me a .xls format of leave record data with the following topics...

20 employees..

following leave

CL -------------- 7

SL -------------- 7

PL -------------- 2 pl added automatically every month from end of 3rd month onward and at the end i.e, 12th month

3 pl will add. total 21 PL.

C/Off ----------- when work in w/off and holidays (1 comp off will add automatically)

Absent --------- as and when required

Present -------- as applicable

Any other Leave.--- as applicable

Moreover holidays as per requirement can be adjusted which will reflect indicating the column colour.

the sheet should be like, i am maintaining the record monthly and a separate sheet for each employee

will create automatically where I can display the summary of each employee at the end of year.

Thanks & Regards,,John

Dear Deepu,
How to show absent in monthly leave sheet.
Thanks & regards.
Kan Singh Rathore