Función de Google Sheets

WEEKNUM

Returns the week number of a specific date within a year.

Generar una fórmula con IA La misma función en Excel

Esta función funciona igual en Google Sheets que en Excel: misma sintaxis y mismos argumentos.

Sintaxis

WEEKNUM(serial_number, [return_type])

The WEEKNUM function calculates the ordinal number of the week for a given date. It identifies which week of the year the date falls into, with the week containing January 1st being considered the first week.

Argumentos

serial_numberobligatorioThe date to evaluate, represented as a serial number or date string.
return_typeopcionalA number determining which day the week begins on (default is 1 for Sunday).

Ejemplos

=WEEKNUM("2023-01-15")

Resultado: 3

Returns the week number for January 15, 2023, assuming the week starts on Sunday.

Preguntas frecuentes

Does WEEKNUM support ISO week numbers?

No, use the ISOWEEKNUM function if you need to follow the ISO 8601 standard.

Funciones relacionadas

ISOWEEKNUM WEEKDAY DATE