Excel WEEKDAY: Return a Day Name from a Date

How-to basics · Updated November 18, 2026

To return a weekday name from a date in Excel, use =TEXT(A2,"dddd"), assuming A2 contains a valid date; for a short name such as Mon, use =TEXT(A2,"ddd"). The WEEKDAY function itself returns a number, not a name, so TEXT is usually the simplest way to display the day.

Get a weekday name with TEXT

TEXT converts a value into text using a format you specify. For dates, the format code dddd displays the full weekday name, while ddd displays an abbreviated name. The original date cell does not have to be changed: put the formula in another cell, then fill it down for the rest of the list.

For example, with the valid date November 2, 2026 in A2, the formula =TEXT(A2,"dddd") returns Monday. With the same date in A2, =TEXT(A2,"ddd") returns Mon. These are text results, rather than date values. That distinction matters if you later sort, calculate with, or use the result in another formula.

To use the formula, select an empty cell beside the date, enter the appropriate version, and press Enter. If the dates continue down column A, select the formula cell and drag its fill handle down, or double-click the fill handle to copy it alongside adjacent data. Excel adjusts A2 to A3, A4, and so on as the formula is copied.

What WEEKDAY returns, and why it is different

WEEKDAY answers a related but different question: it returns a number that represents the day of the week. This is useful for comparisons and calculations, such as checking whether a date falls on a weekend, but it does not directly produce a word such as Tuesday. The optional return_type argument controls which day receives the first number.

  • With the default return type, Sunday is 1, Monday is 2, and Saturday is 7.
  • With return type 2, Monday is 1 and Sunday is 7. This is a common choice for a Monday-to-Sunday workweek.
  • With return type 3, Monday is 0 and Sunday is 6.

For example, if A2 contains November 2, 2026, the formula =WEEKDAY(A2) returns 2 because the default system numbers Sunday as 1. With the same date in A2, =WEEKDAY(A2,2) returns 1 because that numbering starts with Monday. Neither formula returns the text Monday; use TEXT when the desired result is a readable name.

Return a name using WEEKDAY and CHOOSE

There are cases where you may want the weekday name to be determined from a weekday number. CHOOSE can map the number returned by WEEKDAY to a list of names. This approach is more explicit than formatting a date with TEXT, but it requires you to supply the names in the correct order.

Assuming A2 contains a valid date, this formula uses WEEKDAY’s default numbering, where Sunday is first, and returns the corresponding full name: =CHOOSE(WEEKDAY(A2),"Sunday","Monday","Tuesday","Wednesday","Thursday","Friday","Saturday"). For November 2, 2026 in A2, the result is Monday. If you change the WEEKDAY return type, you must also reorder the names to match that numbering; otherwise, the returned name will be wrong.

CHOOSE is handy when you want to control the labels yourself, such as using custom abbreviations or another set of labels. For ordinary weekday names, TEXT is shorter, easier to maintain, and less likely to produce a mismatch between numbering and names.

Choose between a formula and cell formatting

A formula is not always necessary. If you only want the date to look like a weekday while keeping it as a date value, change the cell’s number format instead. Select the date cells, open Format Cells with Ctrl+1 on Windows, choose Number, then Custom, and enter dddd in the Type box. Choose ddd for abbreviated names. In Excel for Mac, Command+1 opens Format Cells; the equivalent custom number-format option is available there as well.

Custom formatting changes only how the date is displayed. The underlying value remains the complete date, so formulas can still compare it with other dates and sort it chronologically. By contrast, TEXT returns a text string containing a weekday name. Use formatting when the date should remain a date for calculations; use TEXT when another formula, report, or export needs the name as text.

A custom format may still show the year, month, or day elsewhere in the workbook only if those elements are included in the format code. A cell formatted as dddd displays just the weekday name, but its formula bar still reveals the underlying date. This can be useful for a compact schedule without sacrificing the date value.

Handle blank cells and date-time values

If your date list contains blank rows, a basic TEXT formula can display a weekday for a blank reference because Excel treats an empty cell like the numeric value zero in some date contexts. To keep the output cell blank when A2 is blank, use an IF check first.

Assuming A2 contains either a date or an empty cell, enter =IF(A2="","",TEXT(A2,"dddd")). When A2 is empty, this returns an empty string; when A2 contains November 2, 2026, it returns Monday. Copy it down beside the list to avoid unwanted names appearing on blank rows.

Excel dates can also include a time component. A cell containing November 2, 2026 at 3:30 p.m. still produces Monday with dddd, because the weekday is determined by the date portion of the value. If the time is stored as text rather than as a real Excel date-time value, however, TEXT may not interpret it as expected.

Language and regional settings

The weekday name displayed by TEXT depends on Excel’s language and regional settings. A workbook opened in a different language environment may display localized day names, and date formats can also be interpreted differently when text is used as input. For dependable results, store dates as actual Excel date values rather than ambiguous strings such as 03/04/2026, which could mean March 4 or April 3 in different regions.

If a formula is rejected even though it looks correct, check the list separator used by your Excel settings. The examples here use commas between arguments, as in =TEXT(A2,"dddd"). Some regional configurations use semicolons instead. Excel may also localize function names in some language editions. These are regional differences, not different meanings of the weekday format code.

For a workbook shared across teams, decide whether day names should follow each user’s Excel language or remain in a chosen language. TEXT is convenient for localized display, but it may not be the best choice when a fixed English label is required for a downstream data feed. In that situation, a controlled mapping such as CHOOSE can make the output labels explicit, provided the mapping is maintained carefully.

Common problems and how to fix them

  • The result is a number: You may be using WEEKDAY, which returns a weekday index. Use TEXT with dddd for a full name, or ddd for an abbreviation.
  • The result is an error or an unexpected name: Check that the source is a real Excel date, not text that only looks like one. You can test a suspicious cell by changing its number format to General; a date value usually appears as a serial number.
  • The name is wrong by one day: Confirm that the referenced cell is the intended date and that a CHOOSE list matches the WEEKDAY return type. A Monday-first numbering system and a Sunday-first name list cannot be mixed without adjustment.
  • Blank rows show a weekday: Wrap the TEXT call in an IF test for an empty source cell, as shown above.
  • The name is abbreviated: Use four d characters for the full name. Three d characters request the abbreviated form.

Be careful when a date has been imported from another system. A text value can look identical to a date but behave differently in formulas. If converting a column, use Excel’s date-conversion tools or correct the import settings, and verify a few results before filling a formula through thousands of rows. Avoid converting dates simply by changing their display format: a number format cannot turn text into a real date.

Use weekday names for sorting and analysis

Weekday text is useful for labels, dashboards, and readable summaries, but alphabetical sorting puts Friday before Monday, not in calendar order. If you need to group or sort records by weekday order, keep the original date or use a numeric weekday key alongside the name. For a Monday-first key, return type 2 makes Monday 1 through Sunday 7, which can be sorted in the desired order.

For example, assuming dates are in A2:A100, put a weekday-number formula beside each date and sort by that helper column. With the date for a row in A2, =WEEKDAY(A2,2) returns a value from 1 to 7. The name can remain in a neighboring column for readers. Keeping the number and label separate prevents the alphabetical order of text from being mistaken for the order of the week.

Also consider what “weekday” means in the context of your task. WEEKDAY classifies all seven days; it does not decide which days count as working days for a particular organization. If a schedule has nonstandard weekends, holidays, or shifts, a simple weekday name is only a label, not a full business-calendar calculation.

Frequently Asked Questions

Does WEEKDAY return the day name?
No. WEEKDAY returns a number based on its return_type setting. Use TEXT with a weekday format such as dddd to return a name.

How do I return only the first three letters?
Assuming A2 contains a valid date, use =TEXT(A2,"ddd"). It returns a localized abbreviated weekday, such as Mon for a Monday date.

Can I show the day name without changing the date?
Yes. Apply the custom number format dddd to the date cell. The cell continues to hold its date value, whereas a TEXT formula produces a separate text result.

Why does my weekday formula show the wrong language?
TEXT normally follows the language and regional settings used by Excel for date formatting. Check those settings or use an explicit label mapping if the workbook requires a fixed set of names.

Can I use the weekday name to sort dates Monday through Sunday?
Not by sorting the names alphabetically. Keep a numeric weekday key, such as the value returned by WEEKDAY with return type 2, and sort by that key instead.

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.