Salary Format - Xls Download [thread 311353]

Pls give me a format in excel where automatically salary monthly basis & salary per day basis with overtime can be calculated. Also explain me how to calculate basic rate of monthly salaried person, whether his basic + DA will be calculated and then divide by 30.

Dear Frds,
There is many posts regarding your queries, you can find by researching with in this forum. (The Research textbox is on the top of the page)
By mean time please refer below excel sheets, which may resolve your queries.
Thanks,

Hi sir
May i know the short cut of filter. that you fixed the filter option to every cell.
I want to know how to do it.