List of Weekdays in Excel: 10 Practical Methods

How-to basics · Updated November 20, 2026

To make a quick list of Monday through Friday in Excel, enter a starting date and use the fill handle or a WORKDAY formula; to show weekday names, format those dates as dddd. The ten methods below cover both meanings of a weekday list—names for all seven days and workday-only schedules—so Excel beginners and regular spreadsheet users can choose the approach that fits their data.

1. Use AutoFill to Create a Weekday Name List

For a simple list of weekday names, type Monday in A1 and Tuesday in A2, select both cells, then drag the small fill handle at the selection’s lower-right corner down five more rows. Excel recognizes the pattern and continues Wednesday through Sunday; for a Monday-to-Friday list, stop after Friday. Starting with two names is useful because it shows Excel the sequence and avoids repeatedly copying the same word. You can also select the two cells and choose Home > Fill > Series if you prefer a ribbon command. This method creates text rather than dates, so it is handy for labels, headings, and simple checklists, but the results cannot be used directly for date calculations.

2. Fill a Series of Dates That Skips Weekends

If you need actual dates for Monday through Friday, enter a Monday date in a cell, select it, and choose Home > Fill > Series. In the Series dialog, choose Columns or Rows to match the layout, select Date as the series type, select Weekday as the date unit, and set the step value to 1. Excel fills consecutive workdays and skips Saturday and Sunday. A real date series is more useful than weekday-name text for schedules because you can sort it chronologically, calculate durations, and apply date formats. Add a stop value if you want Excel to end on a particular date rather than filling a predetermined number of cells.

3. Generate Five Workdays with a Dynamic Formula

In Microsoft 365 or Excel 2021, a dynamic array formula can return five consecutive Monday-to-Friday dates in one step. With the output starting in A2 and Monday, January 5, 2026, as the starting date, enter =WORKDAY(DATE(2026,1,5)-1,SEQUENCE(5)) in A2. The result spills into five rows: January 5, 6, 7, 8, and 9, 2026. The subtraction makes the day before Monday the starting point, so WORKDAY returns Monday as the first workday. Format the spilled dates with dddd if you want names instead of date numbers. Leave the cells below A2 empty so Excel has room to display the spill range.

4. Extend a Workday Schedule with WORKDAY

WORKDAY is a practical choice when a schedule needs to continue one row at a time and skip weekends. With the starting date in A2 and a holiday list in F2:F10, enter =WORKDAY(A2,1,$F$2:$F$10) in A3, then copy it down. If A2 contains Thursday, January 1, 2026, and the holiday range is empty, A3 returns Friday, January 2; the next copied result is Monday, January 5. The holiday argument is optional, but listing dates such as observed public holidays prevents them from appearing as working days. Apply a date format or use a separate weekday-name column to make the schedule easier to scan.

5. Set a Different Weekend with WORKDAY.INTL

Not every organization treats Saturday and Sunday as the weekend. WORKDAY.INTL lets you specify a different weekend pattern while still producing real dates. With a starting date in A2 and any excluded holidays in F2:F10, enter =WORKDAY.INTL(A2,1,7,$F$2:$F$10) in A3 and fill down. Weekend code 7 means Friday and Saturday are nonworking days. If A2 is Thursday, January 1, 2026, and there are no holidays in the range, the next working date is Sunday, January 4. Check the weekend-code table in Excel Help if your pattern differs; WORKDAY.INTL also accepts a seven-character weekend string for more unusual schedules.

6. Convert a Date into Its Full Weekday Name

When a cell already contains a valid date and you want the weekday as text in another cell, use TEXT. With January 5, 2026, in A2, enter =TEXT(A2,"dddd") in B2 to return Monday, then copy the formula down alongside the other dates. This separates the underlying date from its displayed name, which can be convenient for reports that need both columns. The four d characters request the full weekday name; the returned text is not itself a date and should not be used for date arithmetic. The name follows Excel’s language and regional settings, so a workbook configured for another language may display the corresponding localized weekday.

7. Show Short Names with the ddd Format Code

Compact reports often need Mon, Tue, and Wed rather than full names. With a date in A2, enter =TEXT(A2,"ddd") in B2 to return its abbreviated weekday name, then fill the formula down. For a date of January 5, 2026, the result is Mon. This is useful in narrow calendar columns, chart labels, or weekly summaries where full names would take up too much space. Like the full-name version, TEXT returns text and respects Excel’s language settings. If users need to sort by weekday order rather than alphabetically, keep a date or numeric weekday column as well; sorting the abbreviations alone may put them in an unexpected order.

8. Map a Date to a Name with WEEKDAY and CHOOSE

WEEKDAY can turn a date into a number, and CHOOSE can map that number to a written name. With a date in A2, enter =CHOOSE(WEEKDAY(A2,2),"Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday") in B2. The return type 2 numbers Monday as 1 and Sunday as 7, so a date of January 5, 2026, returns Monday. This approach is useful when you want the names hard-coded in a particular language or order rather than relying on a display format. It is less convenient to maintain than TEXT if you later want localized names, because you must edit the formula’s text values yourself.

9. Add a Weekday Drop-Down List with Data Validation

A drop-down is useful when people should choose a weekday instead of typing one, for example in a shift-assignment or appointment form. Put Monday through Friday in H2:H6, select the input cells, then choose Data > Data Validation. Set Allow to List and use =$H$2:$H$6 as the Source. The list stays easy to maintain: change the source cells to add weekend options or use a different order. Keep the source range on the same worksheet for this straightforward reference, and consider hiding the helper column only after confirming users can still find and maintain the list. Data validation guides entry, but it does not create a date or automatically prevent every kind of pasted value.

10. Display Weekday Names Without Changing the Dates

If you want a date column to show weekday names but remain usable in calculations, change its number format instead of converting the values to text. Select the date cells, open the Format Cells dialog with Ctrl+1 on Windows, choose Custom, and enter dddd as the format. The dates still contain their original serial values, but they display as Monday, Tuesday, and so on. Use ddd for shorter labels such as Mon. This is especially valuable in calendars and work schedules, where the same cells may need to display a weekday while still supporting sorting, date subtraction, and formulas. On Mac, Command+1 opens Format Cells; the formatting principle is the same.

How to Choose

First decide whether the list should contain all seven named days or only working days. For a reusable Monday-to-Friday schedule, use Fill Series with the Weekday date unit, WORKDAY, or WORKDAY.INTL; those methods return genuine dates and can account for weekends or holidays. Choose AutoFill when you only need static labels and do not need calculations. If dates already exist, use a dddd or ddd number format when you want to preserve the dates, or TEXT when a separate text label is specifically useful. For formula-driven weekday names, CHOOSE and WEEKDAY give explicit control over the wording, while TEXT is shorter and follows Excel’s locale. Use Data Validation when the goal is consistent user input, not automatic date generation. Finally, check your Excel version before using SEQUENCE: it is available in Microsoft 365 and Excel 2021, while the fill tools, WORKDAY, TEXT, and WEEKDAY approaches suit a wider range of Excel versions.

Frequently Asked Questions

How do I make Excel continue Monday, Tuesday, Wednesday?
Select at least Monday and Tuesday, then drag the fill handle down. Excel detects the sequence and continues the weekday names.

How can I list weekdays without weekends?
For date values, use Home > Fill > Series and choose Date, then Weekday. For a formula-based schedule, WORKDAY skips Saturday and Sunday by default.

Does WORKDAY include holidays?
It skips weekends by default. To skip holidays too, provide a range of holiday dates as its third argument, as in the examples above.

How do I show a weekday but keep the date?
Apply the custom number format dddd to the date cells. The displayed weekday changes with the date, while the underlying values remain dates.

Why does my weekday name appear in another language?
TEXT and date formats use Excel’s language and regional settings. If you need fixed English labels, use explicit names in a CHOOSE formula or a source list.

Final Thoughts

For a quick text list, AutoFill is simplest; for work schedules, use real dates with Fill Series, WORKDAY, or WORKDAY.INTL. Choose TEXT, CHOOSE, or a number format based on whether you need a separate name or want to preserve the date in place. Matching the method to the data makes the list easier to update and more reliable to calculate.

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.