Hr Executive Related All File - Xls Download

Sir
please help me for hr related file

Hello All,
Plz tell me how to use formula in attendance sheet in case I want to make an condition that if any employee take more than two leaves in a month than 3rd leave will be counted as absent. And it should not be counted in paid days. I mean to say that 1st & 2nd leaves will be counted as paid leaves and 3rd onward leave will be counted as absent, hence shall not be counted in number of paid day.
Thanks & Regards,
Jaswinder Singh
[Login to view]

Dear Jaswinder,
First send me your exsisting formate for instance then i can tell you what will be the formula as you required.
With regards,
Pratul

Hello Praful,
Thanks for ur keen interest in my query. I'm sending u the attachment of my requirement. Plz put the formula in Leave Cell.
Thanks & With Regards.
Jaswinder Singh

i dear
i want to join hr line and pursuing my mba i want to know all information for hr post. plz tell me about it everything.
this is my mail id [Login to view] and this my cell no. +919991090625

Hi Jaswinder,
I have attached your file with my idea of calculating the extra leaves as absent. please go thro' it if u think it is useful. The colored columns u can use only for calculation & keep it hide, hence it will not confuse while entering the data.
Regards,
Suvarna Alhat