How to Display Spanish Day Names in English Excel
Question details
The user needs to format date values to display the days of the week in Spanish while using an English-language version of Excel.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Formatting dates for a multilingual spreadsheet, international report, or localized data presentation.
- Observed behavior
- By default, the English version of Excel returns date formats in English. A specific regional locale code must be applied within the formula to force the output into Spanish.
Ensure you have a cell with a valid date value or use the TODAY() function. Also, verify whether your system's regional settings use commas or semicolons to separate formula arguments.
Use the TEXT Function with a Spanish Locale Code
Apply a specific locale code within the TEXT function to force Excel to return the day name in Spanish, regardless of the default interface language.
Excel allows users to override the default language settings for specific cells by embedding a locale code inside the format text string of the TEXT function. The code [$-0C0A] specifically targets the Spanish (Spain) language.
Click on the blank cell where you want the translated Spanish day name to be displayed.
Type the formula =TEXT(TODAY(),"[$-0C0A]dddd") into the formula bar. In this formula, [$-0C0A] specifies the language, and dddd tells Excel to return the complete name of the day.
If Excel throws an error, your computer's regional settings might require semicolons instead of commas. If so, change the formula to =TEXT(TODAY();"[$-0C0A]dddd").
To format a date already present in your sheet rather than today's date, replace the TODAY() function with the specific cell reference, such as =TEXT(A2,"[$-0C0A]dddd").

Easily Manage Multilingual Dates with WPS Spreadsheet
WPS Spreadsheet fully supports advanced text formatting and locale codes, allowing you to quickly format dates into Spanish or any other language. It provides an intuitive interface for all your data localization needs.
- 1. Open your spreadsheet: Launch WPS Spreadsheet and open the document containing your date values.
- 2. Select the destination cell: Click on the cell where the Spanish day name should appear.
- 3. Enter the formula: Input =TEXT(A1,"[$-0C0A]dddd") into the formula bar, replacing A1 with your actual date cell.
- 4. Press Enter: Hit Enter on your keyboard to instantly apply the format and display the day in Spanish.

Frequently Asked Questions
Can I display the month name in Spanish using the same method?
Yes, you can use the identical locale code coupled with month formatting characters. Simply use the formula =TEXT(TODAY(),"[$-0C0A]mmmm") to display the full name of the current month in Spanish.
Is there a locale code for Latin American Spanish?
Yes. While [$-0C0A] specifies Spanish as spoken in Spain, you can use [$-080A] for Mexican Spanish or [$-2C0A] for Argentine Spanish if you need localized variations.
Can I format the cell without using a formula?
Absolutely. You can right-click the date cell, select 'Format Cells', navigate to the 'Custom' category, and enter [$-0C0A]dddd directly into the Type box. This alters the display format while keeping the underlying date value intact.
Why is my formula returning a #NAME? error?
A #NAME? or similar formula error usually occurs due to regional list separator settings. Try replacing the comma in your formula with a semicolon: =TEXT(TODAY();"[$-0C0A]dddd"). Additionally, ensure straight quotes (") are used rather than curly, formatted quotes.




