Sequence of custom days

To generate a dynamic list of dates that include only certain days of the week (i.e. only Mondays, Wednesdays, and Fridays) you can use the WORKDAY.INTL function with the SEQUENCE function. In the example shown, the date in B5 is a hardcoded start date. The formula in B6 is: =WORKDAY.INTL(B5-1,SEQUENCE(B8),"0101011") The formula returns the next 12 Mondays, Wednesdays, and Fridays after the start date in B5. The number 12 comes from cell B8 and the start date comes from B5. If either value is changed, all dates will recalculate.

April 14, 2025 · 1 min · 109 words · Heather Stewart

Table of Contents

If the start date or the number of dates to create is changed, the dates should be recalculated.

WORKDAY.INTL will automatically exclude Saturday and Sunday and can optionally exclude dates that are holidays.

We do this because we want to force WORKDAY.INTL to check the start date as well.

Weekend code options for WORKDAY.INTL

For more details on WORKDAY.INTL, seeHow to use the WORKDAY.INTL function.

Otherwise, the next Saturday or Sunday will be returned.

you’re able to also combine WORKDAY.INTL with SEQUENCE and theFILTER functionto list custom daysbetween two given dates.

Weekend code options for WORKDAY.INTL

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

…

SEQUENCE of dates

How to calculate due dates with WORKDAY

Weekend code options for WORKDAY.INTL

Weekend code options for WORKDAY.INTL

Weekend code options for WORKDAY.INTL

Sequence of custom days - solution for older versions of Excel

Excel formula: Sequence of weekends

Excel formula: Sequence of workdays

Excel formula: List workdays between dates

Excel WORKDAY.INTL function

Excel SEQUENCE function

Sequence of custom days - solution for older versions of Excel