What is WEEKNUM called in Spanish?

In Spanish Google Sheets it is NUM.DE.SEMANA. The formula =WEEKNUM(A2,2) is written =NUM.DE.SEMANA(A2;2) (or with commas under a Mexico locale).

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

Returns a date’s week number in the year. In Spanish Sheets it is called NUM.DE.SEMANA.

Syntax

English Sheets

=WEEKNUM(date, [type])

Spanish Sheets (Mexico locale)

=NUM.DE.SEMANA(fecha, [tipo])

Spanish Sheets (Spain, Latin America)

=NUM.DE.SEMANA(fecha; [tipo])

Argument	What it is
date	The date.
typeoptional	1: weeks from Sunday; 2: from Monday; 21: ISO week.

Example

WEEKNUM(date, 2) gives the week of the year with weeks starting on Monday. Handy for grouping sales or shifts by week. With 21 it uses the ISO week, common in Europe.

=WEEKNUM(A2,2)

Common mistake

With types 1 and 2, week 1 is the one with January 1; Europe usually uses ISO weeks (21).

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 WEEKNUM

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

WEEKNUM

WEEKNUM(date, 2) gives the week of the year with weeks starting on Monday. Handy for grouping sales or shifts by week. With 21 it uses the ISO week, common in Europe.

Example=WEEKNUM(A2,2)NUM.DE.SEMANA = WEEKNUM

In B2, calculate each date’s week number, with weeks starting on Monday.

	A	B
1	Date	Week
2	01/01/2026
3	01/04/2026
4	01/05/2026
5	03/16/2026
6	11/30/2026
7

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

Frequently asked questions

What is WEEKNUM called in Spanish?: In Spanish Google Sheets it is NUM.DE.SEMANA. The formula =WEEKNUM(A2,2) is written =NUM.DE.SEMANA(A2;2) (or with commas under a Mexico locale).
Why does WEEKNUM 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 WEEKNUM mistake?: With types 1 and 2, week 1 is the one with January 1; Europe usually uses ISO weeks (21).