Function Problems

How to Display Spanish Day Names in English Excel

Huda QurayshiHuda Qurayshi Oct 15, 2026 871 views

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.

How to Display Spanish Day Names in the English 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.
Before you start

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.

Solution 1Recommended

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.

1
Select the target cell

Click on the blank cell where you want the translated Spanish day name to be displayed.

2
Input the formatting formula

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.

3
Adjust for regional syntax

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").

4
Reference an existing date cell

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").

Use the TEXT Function with a Spanish Locale Code
Alternative Day Formats: If you only want the abbreviated day name (e.g., 'lun' instead of 'lunes'), change the 'dddd' in your formula to 'ddd'.
Multilingual Data Formatting

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. 1. Open your spreadsheet: Launch WPS Spreadsheet and open the document containing your date values.
  2. 2. Select the destination cell: Click on the cell where the Spanish day name should appear.
  3. 3. Enter the formula: Input =TEXT(A1,"[$-0C0A]dddd") into the formula bar, replacing A1 with your actual date cell.
  4. 4. Press Enter: Hit Enter on your keyboard to instantly apply the format and display the day in Spanish.
Fully compatible with Microsoft Excel formulas, date formats, and locale codes.Seamlessly processes regional modifiers like [$-0C0A] without additional plugins.Lightweight, fast, and completely free to use across Windows, Mac, and mobile devices.
microsoft office alternative - wps office

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.