# How to Calculate the Prorated Salary in Excel -3 Methods

## What Is Prorated Salary?

The prorated salary is the salary paid according to specified working hours or working days.

The dataset showcasesÂ Employee name, Joining Date, and Ending Date.

### Method 1 – Using the YEARFRAC Function to Calculate the Prorated Salary in Excel

Two new columns were added to the dataset: Year Fraction and Amount.

Steps:

• SelectÂ E5.

• Enter the following formula in the selected cell.
`=YEARFRAC(C5,D5,1)`
• Press Enter.

• The year fraction will be displayed.
• Drag down the Fill Handle to see the result in the rest of the cells.

This is the output.

• Select F5 and enter the following formula.
`=\$C\$12*E5`

• Press Enter.

This is the output.

• Drag down the Fill Handle to see the result in the rest of the cells.

This is the output.

### Method 2 – Calculating the Prorated Salary in Excel by Using the DAYS Function.

Steps:

• Select E5

• Enter the following formula in the selected cell.
`=DAYS(D5,C5) + 1`

• Press Enter.
• Drag down the Fill Handle to see the result in the rest of the cells.

This is the output.

• Enter the following formula in F5.
`=(\$C\$12/365)*E5`

• Press Enter.

You will see the result in F5.

• Drag down the Fill Handle to see the result in the rest of the cells.

This is the output.

### Method 3 – Adding a Generic Formula to Calculate the Prorated Salary in Excel

Steps:

• Select E5.
• Enter the following formula in the selected cell.
`=D5-C5+1`

• Press Enter.
• Drag down the Fill Handle to see the result in the rest of the cells.

This is the output.

• Enter the following formula inÂ F5.
`=(\$C\$12/365)*E5`
• Press Enter.

This is the output.

• Drag down the Fill Handle to see the result in the rest of the cells.

## How to Prorate the Semi-Monthly Salary

Steps:

• Select E5.

• Enter the following formula.
`=\$C\$12/2`

• Drag down the Fill Handle to see the result in the rest of the cells.
This is the output.

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

Get FREE Advanced Excel Exercises with Solutions!
Souptik Roy

Souptik Roy, a BSc graduate in Naval Architecture and Marine Engineering from Bangladesh University of Engineering and Technology, dedicated 1.5 years to the ExcelDemy project. During this time, he authored 50+ articles and reviewed 20+ for ExcelDemy. Presently, he is a designer and content developer at YouHaveGotThisMath and Brainor, sister concerns of ExcelDemy. His educational content spans science, mathematics, and grammar. Roy's interests include developing creative ideas, visualizing concepts with tools like Adobe Illustrator, and problem-solving within Microsoft... Read Full Bio

We will be happy to hear your thoughts

Advanced Excel Exercises with Solutions PDF