# How to list biweekly pay dates in Excel

Use SEQUENCE with a step of 14 days: `=SEQUENCE(B2,1,B1,14)`.

**Excel:** `=SEQUENCE(B2,1,B1,14)` (Excel 2021, 2024 and Microsoft 365)

**Google Sheets:** the same formula works.

## Example

Sample data (row 1 is the header):

| A | B | C | D |
| --- | --- | --- | --- |
| First payday | 2026-01-09 |  | Paydays |
| Paydays | 8 |  |  |

Formula in D2: `=SEQUENCE(B2,1,B1,14)`

Result (spills 8 × 1): 1/9/2026; 1/23/2026; 2/6/2026; 2/20/2026; 3/6/2026; 3/20/2026; 4/3/2026; 4/17/2026

## How it works

SEQUENCE takes a step as its fourth argument, so a step of 14 counts up two weeks at a time from the first payday. B2 sets how many dates you get; a year of biweekly paydays is usually 26, and some years have 27.

## Other ways

- `=B1+14*SEQUENCE(B2,1,0)`: Adds 0, 14, 28 … days to the first payday.

## Common mistakes

- Some years have 27 biweekly paydays. Count them for 2026 with `=SUMPRODUCT(--(YEAR(SEQUENCE(27,1,B1,14))=2026))`.
- Paydays that land on a holiday don't move. Use `=WORKDAY(dates+1,-1,holidays)` to pay on the business day before.

## Questions

**How do I list weekly dates?**

Use a step of 7: `=SEQUENCE(B2,1,B1,7)`.

**How do I find the next payday after today?**

`=B1+14*ROUNDUP((TODAY()-B1)/14,0)`.

Every formula and result on this page was checked by running it in the Spreadsheet Practice formula engine on 2026-10-30.

Source: https://spreadsheetpractice.com/formulas/list-biweekly-pay-dates