Biweekly pay schedule

To create a list of pay dates that occur biweekly (every two weeks) on a given day of the week, you can use a formula based on the SEQUENCE function. In the example shown, the formula in cell D5 is: =SEQUENCE(B8,1,B5,14) Where the date in cell B5 is a valid pay date to start from. With 26 in cell B8, the result is a list of 26 pay dates beginning on Friday, January 6, 2023. See below for an explanation and for an alternative formula that takes into account holidays. Note: To list semimonthly pay dates that occur twice monthly, usually on fixed dates like the 1st and 15th, see this example.

April 14, 2025 · 1 min · 91 words · Mr. Keith Gonzalez

A biweekly pay schedule means employees are paid every two weeks on a given day of the week.

We can solve this problem with the SEQUENCE function, as explained below.

When properly formatted, they display as dates.

Formula for biweekly pay schedule excluding holidays

“Fri”) before the date to make it easy to verify correct results.

We have to use a bit of trickery here to get WORKDAY to check the date returned by SEQUENCE.

We do this by asking WORKDAY for the workdaypreviousto the date + 1.

Formula for biweekly pay schedule excluding holidays

The array can be one dimensional, or two-dimensional, determined byrowsandcolumnsarguments.

Formula for biweekly pay schedule excluding holidays

Formula for biweekly pay schedule excluding holidays

Formula for biweekly pay schedule excluding holidays

Excel formula: Semimonthly pay schedule

Excel formula: List workdays between dates

Excel formula: Sequence of weekends

Excel formula: Get first day of month

Excel SEQUENCE function

Excel WORKDAY function

Formula for biweekly pay schedule excluding holidays