# Leave Salary Calculation in Excel (With Easy Steps)

### Step 1 – Creating the Dataset

The dataset for the Leave Salary CalculationÂ should include the employee names and a few quantities like Total working Days, Total Leave etc. for the calculation of the Total Leave Salary.

• We created a dataset with the joining and last working date of 4 employees like below.

### Step 2 – Calculating Total Days, Months, and Years of Working

• For the total working days, copy the following formula in cell C7:
`=C6-C5`
• Press Enter.
• Use the Fill Handle to copy the formula to the right.

Here, in the formula, we subtracted the value of C5 from the value of cell C6.
• For calculating the total years, insert 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.
• Calculate the total months of service by inseting the following formula in cell C9.
`=C8*12`
• Hit Enter and use the Fill handle to copy the formula in the cells to the right.

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

• Input the Yearly Leave in the range of cells C10:F10. This data varies with company policy and the law.

• To calculate the Leave Per Month, copy the following formula in cell C11 and hit Enter.
`=C10/12`
• 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

• Copy the following formula in cell C12 and press Enter.
`=C9*C11`
• Drag 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

• Input the gross salary of the employees in the range of cells C13:F13.

• Copy the following formula in cell C14 to get the Salary Per Leave and hit Enter.
`=C13*12/365`
• Use the Fill Handle to copy the formula in the cells to the right.

Here, we divided the value of cell C13 by 365 and multiplied by 12 to get the Salary Per Leave.
• Insert the following formula in cell C15 to get the Total Leave Salary.
`=C12*C14`
• Hit Enter and useÂ the Fill Handle to copy the formula through the 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.

You can download the practice workbook from here or use it as a template.

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

Get FREE Advanced Excel Exercises with Solutions!
Mehedi Hasan Shimul

Md. Mehedi Hasan, with a BSc in Electrical & Electronic Engineering from Bangladesh University of Engineering and Technology, holds a crucial position as an Excel & VBA Content Developer at ExcelDemy. Driven by a deep passion for research and innovation, he actively immerses himself in Excel. In his role, Mehedi not only skillfully addresses complex challenges but also exhibits enthusiasm and expertise in gracefully navigating tough situations, emphasizing his steadfast commitment to consistently deliver exceptional and quality content.... Read Full Bio