Excel Day Name from Date: Formulas, Formats, and Fixes

To show the day name for a date in Excel, enter =TEXT(A2,"dddd") in another cell, assuming A2 contains a valid Excel date. The result is the full weekday name, such as Monday; use ddd inside the format code for an abbreviation such as Mon.

Get a weekday name with the TEXT formula

Put the date in one cell and the formula in a neighboring cell. For example, if A2 contains 11/2/2026, enter the formula below in B2. The result is Monday, because November 2, 2026 falls on a Monday.

With the date in A2 and the result wanted in B2, use:

=TEXT(A2,"dddd")

To return a shorter label, use this formula with the same cell layout:

=TEXT(A2,"ddd")

That returns Mon for the example date. The formula can be filled down a column: select the cell containing it and drag the fill handle, or copy and paste it into the rows below. Excel adjusts A2 to A3, A4, and so on. In Microsoft 365 for Windows, Mac, and Excel for the web, TEXT works the same way for this task.

The format code controls the amount of the name shown. Four d characters produce the full weekday; three produce an abbreviation. A single d or dd is used for the day of the month, not the weekday, so =TEXT(A2,"dd") returns a number such as 02 rather than Monday.

Show the weekday without a second formula

If you only need the date to look like a weekday in the worksheet, change its number format instead. This keeps the underlying value as a date, which is useful when you still need to calculate with it, sort by date, or use it in other formulas. The display changes, but the stored date does not.

Select the date cells.
Open Format Cells with Ctrl+1 on Windows. In Excel for Mac, Control+1 opens the Format Cells dialog.
Choose the Number tab, select Custom, and enter dddd in the Type box for the full weekday, or ddd for the abbreviation.
Select OK. The cells now display weekday names while retaining their date values.

You can also use the number format controls on the Home tab, though the Custom format is the direct way to enter dddd. On Mac, the Format Cells dialog is also available from the Format menu. Excel for the web supports date number formats, but the controls can be arranged differently from the Windows desktop dialog.

Use this approach when the column should remain a true date column. Use TEXT when you need a separate text result—for example, to build a label, combine the weekday with other text, or keep the original date visible beside the day name.

What Excel is doing with a date

Excel stores a date as a serial number and applies a number format to display it as a calendar date. The weekday is determined by that date value, not by the way the cell happens to look. TEXT reads the value and returns formatted text; a custom number format changes only how the original value is displayed.

This difference matters in later calculations. A date formatted as dddd is still usable in date arithmetic. A result from TEXT is text, so it cannot be used directly as a date in calculations. For instance, a cell displaying Monday because of a custom format remains a date, while a cell containing the result of TEXT is the word Monday.

Excel dates also depend on the workbook’s date system and the computer’s regional settings. For ordinary modern dates entered and displayed consistently, these details are usually invisible. They become relevant when importing data from another system, sharing a workbook across locales, or working with dates that were entered as text.

Choose between TEXT, number formats, and WEEKDAY

The best method depends on what you need to do with the result, not just how you want it to look:

Use TEXT when you need the weekday as a text value in another column or as part of a text label.
Use a custom number format when the cell should still contain a date but display only its weekday.
Use WEEKDAY when you need a number for logic, comparisons, or rules such as identifying weekends.

With a date in A2, this formula returns a weekday number where Monday is 1 and Sunday is 7:

=WEEKDAY(A2,2)

For November 2, 2026, it returns 1. WEEKDAY is useful for calculations, but it does not return the written name. If the output must be the word Monday, use TEXT or convert the weekday number to a label.

One way to map the number to an English name is CHOOSE. With the date in A2 and a Monday-first numbering system, use:

=CHOOSE(WEEKDAY(A2,2),"Monday","Tuesday","Wednesday","Thursday","Friday","Saturday","Sunday")

For November 2, 2026, this returns Monday. The names in this formula are hard-coded in English, so it is less suitable than TEXT when workbook users need labels in another language or based on their regional settings.

Return a blank when the date cell is empty

A formula copied down a long list can show an unintended weekday for empty rows, because Excel may treat a blank reference like zero in a date calculation. Wrap TEXT in IF to keep the output cell empty until a date is present. With dates in A2:A100 and the formula starting in B2, enter:

=IF(A2="","",TEXT(A2,"dddd"))

For an empty A2, the result is an empty string, so B2 appears blank. For a valid date in A2, it returns that date’s full weekday name. Copy the formula down column B as needed. This check is especially useful in report templates and tables where future rows have already been prepared.

The test checks whether A2 is blank; it does not validate every possible entry. If A2 contains a space or an error value, it is not the same as an empty cell. For imported data, check the source column as well as the displayed result.

Fix dates stored as text

If the formula returns an error or an unexpected result, the source may be text that looks like a date rather than an actual Excel date. A common sign is that changing the cell’s number format has no effect. Another is that values imported from a website or CSV file do not sort in chronological order.

When A2 contains date text in a format Excel recognizes under the computer’s regional settings, this formula converts it and returns the weekday:

=TEXT(DATEVALUE(A2),"dddd")

For example, if A2 contains the text 11/2/2026 and Excel interprets it as November 2, 2026, the result is Monday. The same characters can mean different dates in different regions: 11/2/2026 may be read as November 2 or February 11. DATEVALUE follows regional interpretation, so verify the imported dates rather than assuming ambiguous text was parsed as intended.

For a whole column of imported values, it is often better to convert and verify the dates first, then use the basic TEXT formula. Depending on the source and version, Excel’s Text to Columns tool or a deliberate import setting can help parse the data. Avoid changing formats to hide a parsing problem: formatting cannot reliably turn arbitrary text into a real date.

Language, sorting, and other common issues

Weekday names from TEXT generally follow the language and regional settings Excel uses for formatting. That can be helpful for localized workbooks, but it means the same formula may show a different language on another computer. The CHOOSE example instead returns the English labels typed into the formula, regardless of the user’s date display language.

Another common misconception is that a displayed weekday is enough to establish the order of the dates. Text names sort alphabetically, so Friday may appear before Monday. If the rows need chronological order, sort by the original date column. If you need a weekday sequence, use a numeric WEEKDAY helper column and sort by that number, choosing the return type that gives the desired first day of the week.

If the name does not update after changing the date, check that calculation is set to automatic under Formulas > Calculation Options > Automatic. Also confirm that the formula refers to the intended date cell and that the source is a valid date. A formula result formatted with an unusual number format can also look unexpected; for TEXT results, General or Text is normally suitable.

Finally, distinguish the weekday from the day of the month. In a date format, dddd means weekday name, while dd means a two-digit calendar day such as 02. This small difference is responsible for many formulas that appear to return the wrong kind of day.

Frequently Asked Questions

How do I get just the first three letters of the day?
With a valid date in A2, use =TEXT(A2,"ddd"). It returns a short weekday label such as Mon. The exact abbreviation may vary with the language used for date formatting.

How do I show the full day name in the same cell as the date?
Apply a custom number format such as dddd to the date cell. This displays the weekday instead of the usual date appearance but retains the original date value. If you want both the date and name visible, use a custom format that includes date components and dddd, or place a TEXT result in a separate cell.

Why does Excel show a number instead of a weekday?
The cell may be displaying a date serial number, or the formula may be using WEEKDAY, which returns a number by design. Use =TEXT(A2,"dddd") for a text name, or apply the custom format dddd if you want to keep the cell as a date.

Can I get the day name from a date typed directly in a formula?
Yes, but referencing a cell is usually easier to maintain and avoids ambiguity in date parsing. If A2 holds the date, use =TEXT(A2,"dddd"). For a fixed date, DATE can construct an unambiguous date value, but the formula should be chosen carefully for the year, month, and day you intend.

How do I make Monday count as the first day of the week?
For a numeric weekday result, use =WEEKDAY(A2,2); Monday is 1 and Sunday is 7. TEXT returns the name and does not assign a weekday number, so use WEEKDAY when the ordering matters for a calculation or sort.

Try it: the Formula Explainer: paste any formula and see each function and reference in plain English.

More in Formulas & functions

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

Spotted an error in this guide? Let us know.