What is DAY called in Spanish?

In Spanish Google Sheets it is DIA. The formula =DAY(B2) is written =DIA(B2) (or with commas under a Mexico locale).

Why does DAY use semicolons in some spreadsheets?

It depends on each spreadsheet's locale, under File > Settings. Where the comma is the decimal mark (Spain, much of South America), arguments are separated by semicolons. Mexico and United States locales use commas.

Google Sheets DAY function

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

Syntax

English Sheets

=DAY(date)

Spanish Sheets (Mexico locale)

=DIA(fecha)

Spanish Sheets (Spain, Latin America)

=DIA(fecha)

Argument	What it is
date	The date.

Example

When a date arrives as text ("15/03/2026"), Sheets 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 the date is text it returns #VALUE!; convert it first with DATE or VALUE.

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/103

My spreadsheet is inGoogle Sheets functions in English and Spanish

Dates imported as text

When a date arrives as text ("15/03/2026"), Sheets 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 Google Sheets it is DIA. The formula =DAY(B2) is written =DIA(B2) (or with commas under a Mexico locale).
Why does DAY use semicolons in some spreadsheets?: It depends on each spreadsheet's locale, under File > Settings. Where the comma is the decimal mark (Spain, much of South America), arguments are separated by semicolons. Mexico and United States locales use commas.
What is the most common DAY mistake?: If the date is text it returns #VALUE!; convert it first with DATE or VALUE.