# Leave Salary Calculation in Excel (With Easy Steps)

Get FREE Advanced Excel Exercises with Solutions!

Leave Salary means the salary an employee gets even at the time of leave. Leave Salary Calculation is quite vital for any business or company and it varies with different companies. But there are some common procedures to calculate it. In this article, we will discuss the procedures for Leave Salary Calculation in Excel.

## Step by Step Procedures for Leave Salary Calculation in Excel

We can easily calculate the Leave Salary in Excel by following a few steps. Here we are showing the procedure of Leave Salary Calculation step by step.

### Step 1: Creating the Dataset

In this step, we will create the dataset for Leave Salary Calculation which should include the employee names and a few quantities like Total working Days, Total Leave etc. for the calculation of the Total Leave Salary.

• First, we create a dataset having the joining and last working date of 4 employees like below. ### Step 2: Calculating Total Days, Months and Years of Working

In this step, we will calculate the Total Days, Total Years and Total Months of working for each employee.

• For calculating the total working days we write the following formula in cell C7.
`=C6-C5`
• Then we press Enter.
• Further, use the Fill Handle to copy the formula on the cell’s right side. Here, in the formula, we subtracted the value of C5 from the value of cell C6.
• For calculating the total years we have to write the following formula in cell C8 and press Enter.
`=C7/365`
• Use the Fill Handle to copy the formula up to cell F8. We divided the value of cell C7 by 365 to get the Total Year.
• After that, we will calculate the total months of service by writing the following formula in cell C9.
`=C8*12`
• Afterward, we hit Enter.
• Use the Fill handle to copy the formula in the cells beside. Here, we multiplied the value of cell C8 (which is the total years) by 12 to get the total months.

### Step 3: Leave Per Months Calculation

In this step, we will calculate the leave per month for the employees.

• First, we input the Yearly Leave in the range of cells C10:F10. This data varies with company policy and the country’s existing law. • Now, to calculate the Leave Per Month we write the following formula in cell C11 and hit Enter.
`=C10/12`
• Further, use the Fill Handle to copy the formula to the cells on the right side of that row. Here, we divided the value of cell C10 (yearly leave) by 12 to get the leave per month.

### Step 4: Calculating Total Leaves

We will calculate the total leaves for each employee in this step.

• We have to write the following formula in cell C12 and press Enter.
`=C9*C11`
• Next, use the Fill Handle tool up to cell F12. Here, we multiplied the value of cell C9 (Total Months) by the value of cell C11 (Leave Per Month).

### Step 5: Leave Salary Calculation

Now we will calculate the Leave Salary of each employee in this step.

• We ought to input the gross salary of the employees in the range of cells C13:F13. • Then we write the following formula in cell C14 to get Salary Per Leave and hit Enter.
`=C13*12/365`
• After that, use the Fill Handle to copy the formula in the cells beside. Here, we divided the value of cell C13 by 365 and multiplied by 12 to get the Salary Per Leave.
• Lastly, we write the following formula in cell C15 to get the Total Leave Salary.
`=C12*C14`
• Next, hit Enter.
• Use the Fill Handle to copy the formula in the suitable side cells of that row. Here, we multiplied the value of cell C12 (Total Leave) by the value of cell C14 (Salary Per Leave) to get the Total Leave Salary.
• Finally, we get the Total Leave Salary.

## Conclusion

Leave Salary Calculation is quite vital for any company or business. In this article, we have shown the procedures for Leave Salary Calculation in Excel. If you have any queries or suggestions, please let us know by commenting. Please visit our ExcelDemy site for similar articles regarding Excel.

## Related Articles Mehedi Hasan Shimul

Hi! I am Mehedi Hasan Shimul. As I am an Engineer solving different problems with the help of Excel amuses me. I write Excel related different problem solving articles here. Hope it will help you.

We will be happy to hear your thoughts Advanced Excel Exercises with Solutions PDF  