What is DAY called in Spanish?

In Spanish Excel it is DIA. The formula =DAY(B2) is written =DIA(B2) (or with commas in Mexico).

Why does DAY use semicolons in some Excel versions?

It depends on regional settings. Where the comma is the decimal mark (Spain, much of South America), Excel separates arguments with semicolons. English Excel and Mexican Spanish Excel use commas.

Excel DAY function

Returns the day of the month of a date, from 1 to 31. In Spanish Excel it is called DIA.

Syntax

English Excel

=DAY(serial_number)

Spanish Excel (Mexico)

=DIA(núm_de_serie)

Spanish Excel (Spain, Latin America)

=DIA(núm_de_serie)

Argument	What it is
serial_number	The date.

Example

When a date arrives as text ("15/03/2026"), Excel cannot subtract or sort it. Rescue it with DATE: the year is the last 4 characters, the month the middle ones and the day the first 2.

=DAY(B2)

Common mistake

If it returns #VALUE!, the "date" is probably text. Convert it with DATE or DATEVALUE.

About Ads

This site uses Google AdSense to display ads. These ads help us keep WebHerramientas completely free. Ads are managed by Google and meet strict security and privacy standards.

Practice DAY

Type the formula in the sheet and check it instantly. Spanish or English function names both work. See all lessons

Your progress0/94

My Excel is inExcel functions in English and Spanish

Dates imported as text

When a date arrives as text ("15/03/2026"), Excel cannot subtract or sort it. Rescue it with DATE: the year is the last 4 characters, the month the middle ones and the day the first 2.

Example=DATE(RIGHT(A2,4),MID(A2,4,2),LEFT(A2,2))FECHA = DATE DIA = DAY

Step 1/2

In B2, turn the text (day/month/year) into a real date.

	A	B	C
1	Imported text (day/month)	Date	Day
2	15/03/2026
3	01/12/2025
4	28/02/2026
5	09/07/2026
6	31/10/2026
7

Tip: while typing, click a cell or drag across several to insert their reference.

Frequently asked questions

What is DAY called in Spanish?: In Spanish Excel it is DIA. The formula =DAY(B2) is written =DIA(B2) (or with commas in Mexico).
Why does DAY use semicolons in some Excel versions?: It depends on regional settings. Where the comma is the decimal mark (Spain, much of South America), Excel separates arguments with semicolons. English Excel and Mexican Spanish Excel use commas.
What is the most common DAY mistake?: If it returns #VALUE!, the "date" is probably text. Convert it with DATE or DATEVALUE.