**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**.

**Table of Contents**hide

## Download Practice Workbook

You can download the practice workbook from here.

## 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.

**Read More:** **How to Create Salary Slip Format with Formula in Excel Sheet**

### 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.

**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**.

**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.

**C8 (**which is the total years) by

**12**to get the total months.

**Read More:** **How to Calculate Monthly Salary in Excel (with Easy Steps)**

### 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.

**C10**(yearly leave) by

**12**to get the leave per month.

**Read More:** **Per Day Salary Calculation Formula in Excel (2 Suitable Examples)**

**Similar Readings**

**How to Make Salary Sheet in Excel with Formula (with Detailed Steps)****Calculate HRA on Basic Salary in Excel (3 Quick Methods)****How to Create Tally Salary Slip Format in Excel (With Easy Steps)****Calculate Bonus on Salary in Excel (7 Suitable Methods)****How to Calculate Salary Increase Percentage in Excel**

### 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**.

**C9**(

**Total Months**) by the value of cell

**C11**(

**Leave Per Month**).

**Read More:** **How to Calculate Gross Salary in Excel (3 Useful Methods)**

### 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.

**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.

**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**.

**Read More:** **How to Calculate Basic Salary in Excel (3 Common Cases)**

## 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**

**How to Calculate Average Salary in Excel (6 Effective Methods)****How to Calculate Net Salary in Excel (With Easy Steps)****Daily Wages Sheet Format in Excel (with Quick Steps)****How to Calculate DA on Basic Salary in Excel (3 Easy Ways)****How to Calculate Income Tax on Salary with Example in Excel****Attendance Sheet with Salary in Excel Format (with Easy Steps)**