Excel List of Weekday Dates: 10 Ways to Build a List

How-to basics · Updated November 19, 2026

To generate a spillable list of weekdays in Excel for Microsoft 365 on Windows, put the first date in A2 and the number of dates wanted in B2, then enter =WORKDAY(A2-1,SEQUENCE(B2)) in C2. It returns consecutive Monday-to-Friday dates; the methods below cover holiday exclusions, custom weekends, existing date lists, formatting, and ways to keep a schedule dependable.

1. Generate a set number of weekdays with WORKDAY and SEQUENCE

With the starting date in A2 and the requested count in B2, enter this formula in C2: =WORKDAY(A2-1,SEQUENCE(B2)). If A2 is June 1, 2026, and B2 is 5, the spilled results are June 1, 2, 3, 4, and 5, 2026. WORKDAY skips Saturday and Sunday, while SEQUENCE supplies the consecutive workday numbers needed to create the whole list at once.

The starting date can itself be a weekend: WORKDAY moves the first returned date to the next available weekday on or after that date. Leave the cells below C2 clear so the results can spill; if Excel shows a #SPILL! error, move or clear the blocking cell. This is a strong choice for a fresh, automatically recalculated list in Microsoft 365 or Excel 2021, where both functions are available.

2. Build a simple list by filling WORKDAY down

With a weekday starting date in A2, enter the next date in A3 using =WORKDAY(A2,1), then copy A3 downward with the fill handle. For example, if A2 is Friday, June 5, 2026, A3 returns Monday, June 8; dragging the formula down continues June 9, 10, and later workdays. This approach uses one compact formula and does not require a dynamic array to spill.

It is useful when you want to add notes or tasks in adjacent columns, or when a workbook must be easy for colleagues using older Excel releases to follow. Start with a valid date in A2, rather than a text label that only looks like a date, and fill the formula as far as needed. If you insert a holiday-aware formula later, the same fill-down pattern works with WORKDAY’s holiday argument.

3. Skip listed holidays as well as weekends

With the first date in A2, the number of dates in B2, and holiday dates in C2:C10, enter this in D2: =WORKDAY(A2-1,SEQUENCE(B2),C2:C10). If A2 is Monday, June 1, 2026, B2 is 5, and C2 contains June 3, the returned list is June 1, June 2, June 4, June 5, and June 8. The holiday range makes the fifth working day fall on the following Monday rather than the holiday.

Enter actual Excel dates in the holiday cells, not text such as “June 3,” and keep the range pointed at the full holiday list. Blank cells in the range are ignored, so you can reserve extra rows for future dates. This method is particularly useful for a payroll, service, or project calendar that should count business days but not schedule work on company holidays; it does not know your organization’s holidays unless you provide them.

4. Set a nonstandard weekend with WORKDAY.INTL

With a start date in A2, the number of dates in B2, and optional holidays in C2:C10, enter =WORKDAY.INTL(A2-1,SEQUENCE(B2),"0000110",C2:C10) in D2 to treat Friday and Saturday as the weekend. For a Thursday, June 4, 2026 start and B2 equal to 4, the dates returned are June 4, June 7, June 8, and June 9. The seven-character weekend string represents Monday through Sunday, where 1 means weekend and 0 means working day.

Change the string to match the actual schedule: for a Sunday-only weekend, use 0000001, and for a Friday-only weekend, use 0000100. WORKDAY.INTL is worth choosing when the standard Saturday-and-Sunday pattern is wrong, such as for some regional or shift calendars. Check the positions carefully because a single misplaced 1 changes which dates Excel excludes; the holidays argument remains optional if there are no holidays to list.

5. Filter weekdays from dates you already have

With dates in B2:B20 and no blank cells in that range, enter =FILTER(B2:B20,WEEKDAY(B2:B20,2)<=5) in C2. WEEKDAY with return type 2 numbers Monday as 1 through Sunday as 7, so the condition keeps Monday through Friday and FILTER returns the matching dates in order. If the source contains June 6 through June 10, 2026, the result is June 8, 9, and 10.

This is the right option when dates come from an export, a manually maintained calendar, or another calculation and you want to extract only its weekdays rather than generate new dates. It requires Excel 2021 or Microsoft 365 for FILTER, and the output spills into neighboring cells, so leave room below the formula. If the source range includes blanks or text, clean or separate those entries first so WEEKDAY is evaluating actual date values.

6. Find weekdays within a fixed calendar window

With the first calendar date in A2 and the number of calendar days to inspect in B2, enter =LET(d,SEQUENCE(B2,,A2),FILTER(d,WEEKDAY(d,2)<=5)) in C2. If A2 is June 1, 2026, and B2 is 7, the formula examines June 1 through June 7 and returns June 1 through June 5. Unlike a formula that asks for a set number of workdays, this one asks which weekdays fall inside a fixed date span.

That distinction matters for weekly reporting, date windows, and comparing weekdays within a month: a seven-day window will not always contain the same number of weekdays if it starts on a different day or crosses a holiday. This formula filters out weekends but does not remove holidays; use the holiday-aware WORKDAY method when a holiday should be excluded. LET, SEQUENCE, and FILTER are available in Microsoft 365 and Excel 2021, and the formula returns a dynamic array rather than a fixed block.

7. Show weekday names without turning dates into text

With real dates in A2:A20, select that range and press Ctrl+1 on Windows to open Format Cells, choose Number > Custom, and enter ddd, mmm d in the Type box. A stored date such as June 1, 2026 will display as Mon, Jun 1, while the cell remains a numeric date that Excel can sort, subtract, or use in formulas. Choose dddd, mmmm d instead if you want the full weekday and month names.

Formatting is better than converting dates into labels when the list will feed calculations, filters, or charts. The displayed weekday comes from the date value, so changing the underlying date automatically changes its label. On Excel for Mac, use Format Cells from the Home tab or press Command+1; the Custom number format performs the same job, though the dialog layout can differ slightly.

8. Prevent weekend entries with Data Validation

To restrict manual date entries in A2:A100, select that range and choose Data > Data Validation. Set Allow to Custom and enter =WEEKDAY(A2,2)<=5 in the Formula box; because A2 is the top cell of the selection, Excel adjusts the row reference for each cell. A Monday-to-Friday date passes, while a Saturday or Sunday date is rejected under the default error alert.

This check helps when coworkers type dates into a workday-only schedule instead of relying on a generated list. Add an input message explaining the allowed days and keep the error alert enabled so users understand why an entry failed. Validation does not remove weekend dates that are already present, and it does not exclude holidays; use a holiday-aware formula or add a separate rule if company holidays also need to be prohibited.

9. Highlight weekends to audit a date list

With dates in A2:A100, select the range and choose Home > Conditional Formatting > New Rule, then select “Use a formula to determine which cells to format.” Enter =WEEKDAY(A2,2)>5 and choose a fill color; the rule highlights Saturday and Sunday relative to the first selected cell. The return type 2 setting makes the test clear: values 6 and 7 are weekend days.

This is a visual audit, not a filter or a correction, so it is useful for spotting an accidental weekend in a schedule while retaining the original dates for review. Keep the reference as A2 rather than locking the row, so each cell is checked against its own date. If the selected range begins in a different column or row, change A2 to the top-left cell of that selection before saving the rule.

10. Turn a filled list into a reusable Excel Table

Once you have created a workday list with the fill-down method, add a header such as Date and select the header and dates, then press Ctrl+T on Windows and confirm that the table has headers. A Table adds filter controls and expands when new rows are added, which is practical for a task register with columns for owner, status, and due date. The dates remain normal Excel date values, so you can sort them chronologically or apply the weekday display format from the previous method.

Tables are most useful when the list is part of a longer-running tracker rather than a one-time date sequence. Keep the date column separate from notes and avoid typing over a calculated date if you want the workday pattern to continue consistently. On Mac, use Insert > Table or Command+T depending on the Excel ribbon layout; on Windows, Ctrl+T opens the Create Table dialog directly.

How to Choose

Start by deciding whether you need a set number of weekdays or weekdays inside a fixed calendar period. For a set count, WORKDAY with SEQUENCE creates a compact spill list; for a date window, generate the calendar dates and filter them by WEEKDAY. Choose the fill-down version when you need to inspect or edit each row individually, or when workbook compatibility with older Excel versions matters more than a single dynamic formula.

Next, define what “weekday” means for your schedule. WORKDAY assumes Saturday and Sunday are nonworking days, so use WORKDAY.INTL if your weekend differs, and provide a real holiday range if public or company holidays must be skipped. Decide whether the result will be typed into by people or used only as a generated output: Data Validation helps control manual entries, while conditional formatting helps audit dates already on the sheet.

Finally, consider how the list will be used after it is created. Keep dates as numeric values and change their number format for readable labels instead of converting them to text. Use a Table when the dates belong with ongoing records that need sorting and filtering, and leave enough empty worksheet space for a dynamic array to spill. Before sharing a schedule, check the starting date, weekend pattern, holiday range, and displayed date format against the actual work calendar.

Frequently Asked Questions

How do I list weekdays only in Excel?

For a fresh sequence, use WORKDAY with SEQUENCE, such as =WORKDAY(A2-1,SEQUENCE(B2)), where A2 is the first date and B2 is the number of weekdays needed. For an existing date range, FILTER with WEEKDAY can return only Monday-to-Friday entries.

Does WORKDAY exclude holidays automatically?

No. WORKDAY skips Saturday and Sunday by default, but it needs a holiday range as its third argument to skip additional dates. Add actual Excel date values to that range and keep the formula reference pointed at it.

How can I make Saturday a working day?

Use WORKDAY.INTL and specify a weekend pattern that marks only the days your schedule treats as nonworking. Its seven-character pattern runs Monday through Sunday, with 1 for a weekend day and 0 for a workday.

Why does my formula show a #SPILL! error?

A dynamic-array formula cannot place its results because one or more cells in the output area are occupied, merged, or otherwise blocked. Clear the cells where the list should appear, then check that the formula is not inside an Excel Table, where spill formulas are not supported as table-column formulas.

Can I display Monday instead of the date number?

Yes. Apply a custom date format such as dddd to show the full weekday name, or ddd for an abbreviation. The value stays a date, which preserves sorting and date calculations.

Final Thoughts

For most new weekday schedules, WORKDAY with SEQUENCE is the quickest way to create a clean list; add a holiday range or use WORKDAY.INTL when your calendar requires it. If the dates already exist, filter them or audit them with WEEKDAY, then format and organize the finished list so it remains useful as the schedule changes.

Related

Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.

More in How-to basics

Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources

Spotted an error in this guide? Let us know.