What is WEEKDAY called in Spanish?

It has the same name: WEEKDAY. Functions that started in Google Sheets keep their English name even in a Spanish spreadsheet. What changes is the separator: Spain and much of Latin America separate arguments with semicolons.

Why does WEEKDAY 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 WEEKDAY function

Returns a date’s day of the week as a number. It has the same name in Spanish Sheets.

Syntax

English Sheets

=WEEKDAY(date, [type])

Spanish Sheets (Mexico locale)

=WEEKDAY(fecha, [tipo])

Spanish Sheets (Spain, Latin America)

=WEEKDAY(fecha; [tipo])

Argument	What it is
date	The date.
typeoptional	1 (Sunday = 1, default), 2 (Monday = 1) or 3 (Monday = 0).

Example

WEEKDAY(date, 2) returns the day of the week from 1 (Monday) to 7 (Sunday), so a value above 5 is a weekend. Spanish Sheets keeps the name WEEKDAY; DIASEM is the Spanish Excel name.

=IF(WEEKDAY(A2,2)>5,"Weekend","Weekday")

Common mistake

Spanish Sheets keeps the name WEEKDAY (DIASEM is the Spanish Excel name). Use type 2 so weekends are >5.

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 WEEKDAY

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

Your progress0/59

My spreadsheet is inGoogle Sheets functions in English and Spanish

WEEKDAY

WEEKDAY(date, 2) returns the day of the week from 1 (Monday) to 7 (Sunday), so a value above 5 is a weekend. Spanish Sheets keeps the name WEEKDAY; DIASEM is the Spanish Excel name.

Example=WEEKDAY(A2,2)SI = IF WEEKDAY: same name in Spanish

In B2, show "Weekend" if the date is a Saturday or Sunday; otherwise "Weekday".

	A	B
1	Date	Day type
2	10/30/2026
3	10/31/2026
4	11/01/2026
5	11/02/2026
6	11/07/2026
7	11/11/2026
8

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

Frequently asked questions

What is WEEKDAY called in Spanish?: It has the same name: WEEKDAY. Functions that started in Google Sheets keep their English name even in a Spanish spreadsheet. What changes is the separator: Spain and much of Latin America separate arguments with semicolons.
Why does WEEKDAY 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 WEEKDAY mistake?: Spanish Sheets keeps the name WEEKDAY (DIASEM is the Spanish Excel name). Use type 2 so weekends are >5.