To show a date as a weekday in Excel, select the date cells, open Format Cells, choose Custom, and enter ddd for an abbreviated day name or dddd for the full name. The format changes how the date looks, not the date value stored in the cell.
What ddd and dddd mean
Excel’s custom date formats use the letter d to display the day part of a date. The number of repeated letters determines the display:
dshows the day of the month without a leading zero, such as 3.ddshows the day of the month with two digits, such as 03.dddshows the abbreviated weekday name, such as Tue.ddddshows the full weekday name, such as Tuesday.
For example, if a cell contains November 3, 2026, applying ddd displays Tue, while dddd displays Tuesday. These codes identify the weekday from the date; they do not mean “day number of the week.” In particular, d by itself means the day of the month, not a weekday number.
Apply a weekday format in Excel for Windows
In Excel for Microsoft 365 on Windows, use Format Cells to enter a custom code. First select the cells that contain the dates. Then press Ctrl+1 to open the Format Cells dialog, select the Number tab, choose Custom in the Category list, enter ddd or dddd in the Type box, and select OK.
You can also reach the dialog from the ribbon: choose Home > Number and select the small dialog box launcher at the bottom-right of the Number group. Then choose Custom on the Number tab. The exact position of the launcher can vary with ribbon size, but it opens the same Format Cells dialog.
On Excel for Mac, select the cells and press Command+1 to open Format Cells, then choose the custom number format option and enter the code. The Windows shortcut is Ctrl+1; on a Mac, use Command+1. Excel for the web may display workbook formats, but if you cannot enter or edit the custom code in your version, open the workbook in the desktop app to create it.
Useful weekday and date combinations
A custom format can show the weekday alongside other date details. These are formats you can enter in the Type box:
ddd, mmm ddisplays an abbreviated weekday and short date, for example Tue, Nov 3.dddd, mmmm ddisplays a full weekday and month name, for example Tuesday, November 3.dddd, mmmm d, yyyyincludes the four-digit year, for example Tuesday, November 3, 2026.ddd dd-mmm-yyyydisplays a compact date with the abbreviated weekday, for example Tue 03-Nov-2026.
In a date format, m or mm usually means month. Excel can also use these letters for minutes in a time format, where the surrounding format tells Excel how to interpret them. If you are building a combined date-and-time format, check the displayed result and use a known date and time as a test.
Why the date remains a date
Excel dates are stored as numeric values, with the number representing a date and any fractional part representing a time. A custom number format changes the display of that value; it does not replace the date with weekday text. Thus, a cell that displays Tuesday can still be sorted as a date, used in date calculations, or referenced by another formula. This is useful for schedules: you can make a column easier to scan without losing the actual dates needed for sorting and calculations.
Because the value stays intact, changing the format back to a standard date format reveals the date again. A format is therefore different from typing a weekday name into a cell. If the cell contains the text “Tuesday” rather than a genuine Excel date, applying dddd will not turn that text into a date or calculate its weekday.
When you need a weekday number
A custom number format is right when you want a date to look like a weekday name. If you need a numeric weekday value for a calculation, use the WEEKDAY function instead. Its optional second argument determines which day counts as the start of the week.
With the date in A2, this formula returns a Monday-based weekday number, where Monday is 1 and Sunday is 7: =WEEKDAY(A2,2). If A2 contains November 3, 2026, the result is 2 because that date is a Tuesday. The result is a number, so you can use it in comparisons or other calculations.
If you need weekday text in a separate cell rather than a display format, use =TEXT(A2,"dddd"). With November 3, 2026, in A2 and an English-language format setting, this returns Tuesday as text. Unlike a custom number format, the TEXT formula creates text in the result cell, which may be less convenient if you later need to sort or calculate using the original date. Keep the source date if you need both the date value and a text label.
Common problems and fixes
- The code appears literally. The cell may contain text rather than a real date, or the code may have been typed into the cell instead of the Custom Type box. Check whether Excel recognizes the value as a date, then apply the format through Format Cells.
- The result is a number or an unexpected date. The cell may contain a number that is not the date you intended, or an imported value may have been interpreted using a different date order. Check the underlying value and confirm the day, month, and year before changing the format.
- The weekday is wrong. A valid date’s weekday is determined by its actual date value. If the displayed weekday does not match your expectation, inspect the date itself; a day/month reversal during import can produce a different valid date.
- The day name is in another language. Date names are affected by Excel’s language and regional settings. A format that displays Tuesday on one computer may use a different language on another. Review the workbook’s regional context if it will be shared across locales.
- Only the weekday is visible, but you need the full date. The custom format is hiding the month and year, not deleting them. Temporarily apply a full date format, or use a combined format such as
dddd, mmmm d, yyyy.
Custom format versus other ways to show weekdays
Choose a custom number format when the original date should remain usable as a date and the weekday name is only a display choice. Choose TEXT when you specifically need weekday text in a separate cell, such as for a label or a text-based export. Choose WEEKDAY when downstream logic needs a number representing the day of the week.
These options are not interchangeable in every task. A displayed Tuesday is still a date underneath, whereas the output of TEXT is text and the output of WEEKDAY is numeric. For sorting a list in calendar order, sorting the actual date column is usually more reliable than sorting weekday names, which would group matching weekdays rather than order dates chronologically.
Frequently Asked Questions
What custom format shows the full day name?
Enter dddd in the Custom Type box in Format Cells. A date such as November 3, 2026, will display as Tuesday in an English-language setting.
What format shows an abbreviated day name?
Use ddd. It typically displays a shortened weekday name, such as Tue, though the abbreviation depends on the applicable language and regional settings.
Does dddd change the date into text?
No. When applied as a number format, dddd changes only the display. The cell retains its date value and can still be used in date calculations.
How do I show Monday as 1 and Sunday as 7?
Use =WEEKDAY(A2,2) when the date is in A2. The second argument sets Monday as the first day, producing 1 through 7 for Monday through Sunday.
Can I show the weekday and the complete date together?
Yes. Use a combined custom format such as dddd, mmmm d, yyyy to show the full weekday, month, day, and year in one cell.
Related
- What Column Number Is V in Excel? Find It in Seconds
- How to Combine Two Cells in Excel and Keep Both Values
- Column J Number in Excel: How to Find and Use It Easily
Try it: the Date Difference Calculator: days, months, years and weekdays between two dates, with the DATEDIF formulas.
More in How-to basics
- How to Add a Watermark in Word on Windows 11To add a watermark in Word on Windows 11, open the document in the Word desktop app and…
- Microsoft Excel: How to Turn Off Flash FillTo turn off automatic Flash Fill in Microsoft Excel for Microsoft 365 on Windows, go to File >…
- How to Create a Signature Block in Microsoft OutlookTo create a signature block in Outlook, open the signature settings for your version, select New signature, enter…
- Excel Interpolation: How to Estimate Values Between PointsYes. Excel can interpolate between known points with a formula that assumes a straight-line relationship between the two…
- Excel Table Dropdown List: Create and Manage ListsTo add a dropdown list to an Excel table, select the cells in its column, choose Data >…
- How to Block a Sender in the Outlook App on Any DeviceTo block someone in Outlook, open a message from them and use the Block sender option in the…
Sources: Function behaviour and menu paths: Microsoft Support documentation for Excel. Method & sources
Spotted an error in this guide? Let us know.