How To Calculate Salary From Number Of Days In Excel

If the salary is 21711, what would be the CTC?BASIC - 10,001Special Allowance - 5,031Conveyance - 800HRA - 5,001Medical Allowance - 1,250LTA - 833Gross Salary - 22,916PF - 1,250Base Salary - 24,116Based on the above details, what salary hike can be expected?

Hi Arunsinh,I have a query regarding the calculation of salary for a new employee who started working on September 17th in the organization. There were 2 weekends in between, and the total monthly salary is $49,270\. How should we calculate this considering the ...

Hi,Could you please let me know in detail about the calculation of SALARY, i.e., Basic pay, DA, HRA, etc., in terms of percentages (as against CTC)? For example, 50% of CTC is taken as HRA, etc. Please reply to me soon and email me at this address: samia.1982@gm...

Hi all,Please tell me, can we break up the minimum wages or not under the labor act? If yes, what is the formula for calculation?

Hello everyone, I am Vijay.Can anybody elaborate on the meaning of the salary of Rs. 9300-34800, Grade pay Rs. 4200, and applicable allowances as per company rules?

Hi Guys,I have to prepare the salary statement. Can anyone help me with how to calculate it in Excel? I need a formula for the basic salary based on the gross salary and the number of days present.Please help me out; it's very urgent.Thanks,Saravanan

I do not think there is any rule as to the dividing factor, i.e., 31/30 or 26\. It depends from organization to organization. Organizations either take 30 or 31 as they give advantage to the employees for LOP deductions. Presently, organizations like to be lenie...

Dear Balram,As you are aware, in a month, we will not calculate W-off as working days. Only for PF and ESI, we will calculate based on 31/30/28 days. Salaries can be calculated for 26 days.Thank you.

Dear Ajit,Please send me the salary structure for the plastic industry, including basic, DA, gross, and deductions like PF, PT, etc.Regards,Ajit