Treat holidays consistently in both counts
If a holiday is excluded from scheduled working days, apply the exclusion to the full-period denominator and the eligible numerator where relevant. Excluding it from only one side changes the fraction inconsistently. A day that was not scheduled for this employee should not become payable work merely because another employee normally works that weekday. For a rotating roster, count actual eligible scheduled days or hours under the stated method rather than borrowing a generic office calendar. Keep the roster or holiday list with the calculation for later reconciliation.
Check adjacent service periods as a diagnostic. Under one consistent monthly calendar method, two non-overlapping eligible intervals covering the entire month should sum to the full monthly amount before rounding. If they do not, look for a missing boundary day, duplicated date or differing divisor. This is an arithmetic check, not authority to change an employer's policy. A payment outside the ordinary salary cycle also needs its actual reporting period rather than an assumed monthly fraction.
Choose the contractual basis before counting days
Prorated salary is a portion of a stated full-period salary. For a day-based method, the basic relationship is period salary × eligible days / full-period days. Both day counts must use the same definition. Calendar days include weekends; working days follow the relevant schedule. The equation does not choose the correct employment rule. These educational examples compare stipulated methods, while the contract, payroll policy and applicable rules determine the method for an actual payment.
Work a calendar-day example
Consider November 2026, a 30-day month, with monthly salary 3,600 and employment from November 16 through November 30 inclusive. Under an explicitly agreed calendar-day-in-month method, eligible days are 15. Prorated gross is 3,600 × 15/30 = 1,800. Inclusion of both dates matters: subtracting date numbers without adding one would count 14. Confirm that the employee qualifies for the end date rather than assuming every start or departure date is paid.
Compare a working-day calculation
Now stipulate Monday through Friday working days, no excluded holidays and the same inclusive employment dates. November 2026 has 21 such weekdays; the eligible interval has 11. Under a working-day-in-month method, gross is 3,600 × 11/21, approximately 1,885.71. The difference from 1,800 follows from different denominators and eligible-day definitions. Neither answer establishes which method payroll owes. A weekend worker or rotating shift requires the actual schedule rather than this five-day illustration.
Keep annual divisors separate from monthly fractions
An annual salary divided by 365 and multiplied by eligible calendar days is another stipulated model, not an algebraic synonym for monthly proration. At annual 43,200 and 15 days, it gives about 1,775.34. An annual working-day divisor can likewise differ from the actual month's count. Leap-year treatment and fixed-divisor conventions must be named. Do not combine a monthly salary numerator with an annual denominator unless the formula explicitly converts the period first.
| Method | Calculation | Illustrative gross |
|---|---|---|
| Calendar days in month | 3,600 × 15/30 | 1,800.00 |
| Weekdays in month | 3,600 × 11/21 | 1,885.71 |
| Annual calendar divisor | 43,200 × 15/365 | 1,775.34 |
November 16–30, 2026 inclusive; weekday example excludes no holidays. These are comparisons, not a prescription of payroll rules.
Build consistent spreadsheet counts
If A2 is the first eligible date and B2 the last, a simple inclusive calendar count is =B2-A2+1 after validating B2>=A2 and that both dates fall in the pay period. Working-day functions need the same weekend pattern and holiday list in both numerator and denominator. A monthly schedule with four-day weeks cannot use a generic Monday-to-Friday count. Validate counts against a calendar before trusting a formula whose dates were imported as text.
Separate part-time status and partial-month service
A part-time annual salary may already reflect reduced contractual hours. Do not apply the hours fraction again when prorating that actual salary for a partial month. If an advertised amount is FTE, first obtain the actual contractual amount on the stated hours and paid-week basis. Then apply the partial-period rule if appropriate. Keep overtime, allowances, unpaid absence and variable earnings separate unless their terms explicitly follow the same proration rule as basic salary.
Use the Salary Calculator within its scope
The Salary Calculator converts gross amounts among hourly and annual or periodic equivalents. It does not select a day-count policy or calculate partial-month payroll automatically. With annual gross 43,200, its monthly comparison is 3,600. Apply the agreed 15/30 or 11/21 fraction separately. Changing paid weeks in annual mode keeps the annual amount fixed and alters its hourly equivalent; that action does not implement either partial-month method shown here.
Reconcile precision and explain the result
Retain the exact fraction until the chosen rounding point. Rounding a daily rate before multiplying can differ from rounding the final amount once. Record the full-period salary, dates, inclusive convention, schedule, excluded holidays, divisor and rounding rule. Gross salary is not take-home pay, and a difference between two models is not proof of a payroll error. A useful reconciliation identifies the policy and the count that produced the amount before discussing any discrepancy.