Calculate Per Day Salary in Excel: 2 Formulas

The following table has Name, Designation, and Salary columns.

Per Day Salary Calculation Formula in Excel


Formula 1 – Using a Generic Formula to Calculate Per Day Salary in Excel

Steps:

  • Enter the following formula in E5.
=D5/30

Formula Breakdown

  • Divide D5 by 30.
  • $8000/30 → becomes
    • Output: $266.67
    • Explanation: Here, $266.67 is the Per Day Salary.
  • Press ENTER and see the result in E5.
  • Drag down the formula across the cells you want to fill with the Fill Handle tool.

The calculated per day salary is displayed in the Per Day Salary column.

Per Day Salary Calculation Formula in Excel


Formula 2 – Using a Combined Formula to Calculate Per Day Salary in Excel

Steps:

  • Calculate PF (Provident Fund). PF for each employee is 10% of their Basic Salary, here.

Enter the following formula in D17.

=C17*10%

Formula Breakdown

  • C17*10% → multiplies cell C17 by 10%.
  • $8000*10% → becomes
    • Output: $800 is the PF of a particular employee.
  • Press ENTER and see the result in D17.
  • Drag down the formula across the cells you want to fill with the Fill Handle tool.

Calculate Tax by using the IF function.

  • Enter the following formula in E17.
=IF(C17>=6000,C17*12%,C17*8%)

Formula Breakdown

  • IF(C17>=6000,C17*12%,C17*8%) → the IF function returns C17*12% when C17>=6000 is TRUE, otherwise it returns C17*8%.
  • IF(8000>=6000,8000*12%,8000*8%) → becomes
    • Output: $960. As the logical_test is TRUE, the result becomes 8000*12% which is $960.
  • Press ENTER and see the result in E17.
  • Drag down the formula across the cells you want to fill with the Fill Handle tool.

Per Day Salary Calculation Formula in Excel

Calculate Total Deduction by using the SUM function.

  • Enter the formula in F17.
=SUM(D17,E17)

Formula Breakdown

  • SUM(D17,E17) → adds cell D17 with cell E17.
  • SUM(800,960) → becomes
    • Output: $1760 is the Total Deduction of a particular employee.
  • Press ENTER and see the result in F17.
  • Drag down the formula across the cells you want to fill with the Fill Handle tool.

Calculate Net Salary.

  • Enter the following formula in E5:
=D5+E5-F17

Per Day Salary Calculation Formula in Excel

Formula Breakdown

  • D5+E5-F17 → adds cell D5 to cell E5 and subtracts F17.
  • 8000+1000-1760 → becomes
    • Output: $7240 is the Net Salary of a particular employee.
  • Press ENTER and see the result in F5.
  • Drag down the formula across the cells you want to fill with the Fill Handle tool.

Calculate Per Day Salary by using a division formula.

  • Enter the following formula in G5.
=F5/30

Formula Breakdown

  • Divide cell F5 by 30.
  • $7240/30 → becomes
    • Output: $241.33 is the Per Day Salary of a particular employee.
  • Press ENTER and see the result in E5.
  • Drag down the formula across the cells you want to fill with the Fill Handle tool.

The calculated per day salary is displayed in the Per Day Salary column.

Per Day Salary Calculation Formula in Excel


Practice Section

You can download the Excel sheet below for further practice.

Per Day Salary Calculation Formula in Excel


Download Practice Workbook


<< Go Back to Salary | Formula List | Learn Excel

Get FREE Advanced Excel Exercises with Solutions!
Afia Kona
Afia Kona

Afia Aziz Kona, a graduate of Civil Engineering from Khulna University of Engineering & Technology, Bangladesh, serves as a technical content creator in the ExcelDemy project. Possessing a passion for innovation and critical thinking, she actively embraces challenges. Beyond her engineering background, Afia exhibits a keen interest in Excel, having authored numerous articles on Excel & VBA-related issues to simplify the experience for users facing obstacles in Excel. Apart from creating Excel tutorials, she is also... Read Full Bio

We will be happy to hear your thoughts

Leave a reply

Advanced Excel Exercises with Solutions PDF

 

 

ExcelDemy
Logo