Payroll holiday pay average worksheet calculator

Calculate average of selected eligible weeks and illustrative pay for entered holiday weeks with your own figures.

Your numbers

Use the units shown. Results update as you change valid inputs.

Choose the currency for these amounts. Changing it keeps your numbers and does not convert exchange rates.

Use average of selected eligible weeks and illustrative pay for entered holiday weeks to compare changes to your inputs. The method and limits below explain the scope.

Examples

Examples

Try the starting example

Weeks newest first: label, eligible gross $, include yes/no
W4,0,no W3,100,yes W2,200,yes W1,300,yes
Qualifying weeks required
2
Holiday weeks to illustrate
2
Average of selected eligible weeks ($)
$150.00
Illustrative pay for entered holiday weeks ($)
$300.00
Selected qualifying weeks
W3, W2
Newest-first records examined
3

Try another scenario

Weeks newest first: label, eligible gross $, include yes/no
W4,0,no W3,100,yes W2,200,yes W1,300,yes
Qualifying weeks required
3
Holiday weeks to illustrate
2
Average of selected eligible weeks ($)
$200.00
Illustrative pay for entered holiday weeks ($)
$400.00
Selected qualifying weeks
W3, W2, W1
Newest-first records examined
4
Calculation method

Calculation method

Average of selected eligible weeks ($)

Select the requested number of rows explicitly marked include yes, newest first; divide their gross total by the selected count.

Illustrative pay for entered holiday weeks ($)

Round the unrounded selected-week average×entered holiday weeks to US cents.

Selected qualifying weeks

Return selected labels in selection order.

Newest-first records examined

Count records examined through the final selected week. Reject insufficient qualifying history.

Symbols and units
a
Weeks newest first: label, eligible gross $, include yes/no
b
Qualifying weeks required
c
Holiday weeks to illustrate

Use the units shown. A list keeps the order in which you enter its values. The symbol ^ means “raised to the power of”.

Assumptions & limits

Assumptions & limits

  • A supplied qualifying-week average, with no automatic decision about excluded weeks, reference-window rules, normal remuneration or statutory holiday entitlement.
Are these inputs private?

These calculations run in your browser. A shared link contains the values you choose to share. Only questions submitted to the separate AI finder are sent to OpenAI.

Further reading

US Department of Labor: pay/time recordkeeping background; actual rules vary ↗

Background reading; this does not imply endorsement or independent review of SumFizz.

Share this page
Share this calculator

Leave unchecked to share the page without your entered values.