Salary proration calculator: prorated salary by working days and public holidays
This salary proration calculator helps you calculate a prorated salary for any date range inside a payroll period. It uses working days, meaning weekdays minus public holidays, based on the selected country and optional region.
This answers a common payroll question: how much salary should be paid when an employee works only part of a month?
Instead of dividing salary by calendar days, the calculator uses working days. This produces more accurate results, especially in months with public holidays or regional differences.
How salary proration works
Salary proration is typically calculated using working days within a payroll period.
The logic is simple:
- determine total working days in the payroll period
- determine working days in the selected date range
- calculate proportional salary based on those values
In practice:
prorated salary = (worked days / total working days) * full salary
Public holidays are excluded automatically based on the selected country and subdivision, ensuring compliance with local payroll expectations.
Why working days matter for payroll
Using calendar days for salary proration often leads to inaccurate results. Months vary in length, and public holidays reduce actual working time.
Working-day-based proration is more consistent because:
- it reflects actual working time
- it adjusts for public holidays automatically
- it aligns better with payroll and HR practices
This is especially important in countries where public holidays differ by region or where payroll must follow local labor rules.
Payroll periods and proration windows
The calculator supports two approaches:
- full calendar periods, such as a full month or year
- custom date ranges within a payroll period
This allows you to handle real-world cases such as:
- employee joining mid-month
- employee leaving before the end of the period
- unpaid leave or partial attendance
- contract start and end adjustments
If no custom window is selected, the calculation assumes the full payroll period.
Public holidays and regional differences
Public holidays are applied automatically based on the selected country. If a subdivision is chosen, regional public holidays are also excluded.
This ensures that salary proration reflects local conditions. For example, two employees in different regions of the same country may have different working-day counts due to regional holidays.
Custom work schedules
By default, the calculator assumes a standard Monday-to-Friday workweek. You can change this using predefined schedules such as:
- Monday to Saturday
- Sunday to Thursday
- every day
This makes the calculator suitable for industries with non-standard schedules, including retail, logistics, and shift-based operations.
Salary proration for international teams
For companies with employees in multiple countries, salary proration must be calculated per location. Public holidays and working patterns differ, so a single global formula is not reliable.
Use the calculator separately for each country and region, then combine results in your payroll system.
Using salary proration in your own software
This page is designed for quick calculations. For automation, you can use the HolidayDB APIs.
The salary proration logic is based on working-day calculations using public holiday data. The same rules are available via GET /api/salary-proration, allowing you to integrate accurate prorated salary calculations into your own systems.
Public holiday rules come from GET /api/holidays, so your payroll logic stays consistent with real holiday calendars without maintaining your own datasets.