Guides › Budgeting on a biweekly paycheck: the spreadsheet setup that handles 3-paycheck months · Updated 30 Oct 2026

Budgeting on a biweekly paycheck: the spreadsheet setup that handles 3-paycheck months

If you are paid every two weeks, you get 26 paychecks a year, not 24. That means two months a year have three paydays. A monthly budget hides that; a per-paycheck budget uses it.

List your paydays

Put your first payday of the year in A2 and in A3:

=A2+14

Copy down to 26 rows. Next to each, the month: =TEXT(A2,"mmm"). Count paydays per month with =COUNTIF(B:B,"Mar"), and you'll see which months have three.

Assign each bill to a paycheck

On a Bills sheet: Bill, Amount, Due day. For each bill, pick the last payday on or before the due date. That is the paycheck that pays it. One formula does this for a given month:

=MAXIFS(Paydays!A:A, Paydays!A:A, "<="&DATE(year, month, due_day))

Plan the third paycheck

Decide in January what the two "extra" paychecks do: an emergency fund, an extra debt payment, or annual bills like insurance. Writing it down early is what stops it from disappearing.

Check it each payday

Each payday, look at one row: income in, bills assigned to this check, what's left. If "what's left" is negative, move a bill to the next check before it's due.

Rather start with a ready-made file?

The Paycheck Budget & Debt Payoff Planner does this for weekly, biweekly, twice-monthly or monthly pay, with a bill calendar and a debt payoff calculator. Your data stays in your own file.